Date

Manipulate Date and Time is never easy but Excel can help you with formulas or specific techniques

Calculate the Next Monday with Excel

Formula to calculate the next Monday with Excel, from TODAY or any date.

Calculate Monday in 2 weeks with Excel

Formula to calculate Monday in 2 weeks with Excel, from TODAY or any date.

Formula to calculate the previous monday from today

Calculate the Previous Monday with Excel

Formula to calculate the previous Monday with Excel, from TODAY or any date.

Excel formula monday previous week from today

Calculate Monday Previous Week with Excel

Formula to calculate Monday for the previous week with Excel, from TODAY or any date.

Excel formula to calculate monday 2 weeks ago

Calculate Monday 2 weeks ago with Excel

Formula to calculate Monday 2 weeks ago with Excel, from TODAY or any date.

Display negative time in Excel

Learn how to handle negative hours in Excel with these 3 simple methods. From formatting cells to using formulas, all explanations here.

Power Query Split Date and Time

This step-by-step guide will walk you through the process of split your date and time data with Power Query.

Formula to Calculate Quarter with Excel

Easily determine the quarter for any date with these Excel formulas. Learn how to calculate quarters in Excel in just a few steps.

The WEEKDAY function – Secrets and Errors

=WEEKDAY(Date,Localization) How to use the WEEKDAY function The WEEKDAY function operates with minimal arguments, just a date =WEEKDAY(A1) Yet the returned result may pose confusion. The 13/11/2023 is a Monday and the WEEKDAY function returns 2; WHY? The function, developed by Microsoft, an American company, reflects the U.S. convention where the week starts on Sunday, […]