Happy Leap Year with Date Functions in Excel

As 2020 is a leap year, this month we have an extra day in the calendar.  Those who are on a fixed monthly salary are complaining that they are not getting paid for working the extra day, but I do hope you are enjoying your day anyway, as this is something that only happens once every four years!

If you work in financial modelling or analysis you’ll know that the uneven number of days in each month causes quite a headache for financial calculations and reporting, especially with calculating interest payments, salaries or anything time-based.  Excel does handle date-based calculations very well with handy functions such as =TODAY() or =NOW() which will always give you the current date, or date and time.