When months is negative, the function returns a past date. Use 0 to return the last day of the specified month. Now that you know a little about the function, let’s try a simple example that ...

Fortunately, Excel’s TODAY() function always equals the current date, ... As you can see, the current date is December 6. Figure A. Use a built-in rule to highlight the current date.

Excel's Date & Time functions help you calculate a day's serial number, move to a 360-day accounting calendar, and more. ... Returns the current date formatted as a date.