Calculating the difference between two times in Excel can be tricky.
Date & Time
To enter today’s date in Excel, use the TODAY function. To enter the current date and time, use the NOW function.
Learn how to get the day of the week of a date in Excel and how to get the number of weekdays or workdays days between two dates.
An easy formula that returns the quarter for a given date.
To get the date of the last day of the month in Excel, use the EOMONTH (End of Month) function.
An easy formula that returns the day of the year for a given date.
To calculate the number of days until your birthday in Excel, execute the following steps.
This example teaches you how to get the date of a holiday for any year (2020, 2021, etc).
To get the number of days, weeks or years between two dates in Excel, use the DATEDIF function.
To calculate the age of a person in Excel, use the DATEDIF function and the TODAY function.