Using Date & Time Functions
Calculating Dates
You can use different formulas to return a specific date. Here are some common examples you can use.
Calculate a Specific Day
You can use the DATE function to quickly calculate a specific day, such as New Year’s (January 1st) or Christmas (December 25th).
=DATE(A1,1,1)=DATE(A1,12,25)
Calculate a Changing Day
You can use the DATE and WEEKDAY function to calculate a holiday that changes each year, such as Thanksgiving, which is celebrated on the fourth Thursday in November.
=DATE(A1,11,1)+IF(5<WEEKDAY (DATE(A1,11,1)),7-WEEKDAY(DATE(A1,11,1))+5,5-WEEKDAY(DATE(A1,11,1)))+((4-1)*7)
Calculate the Day of the Year
You can calculate the day of the year for a specific date in the A1 cell. This function ...
Get Excel® 2013 On Demand now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
