Calculating dates in exce dating
Excel has a few additional functions to make declaring dates easier.
Occasionally, it may be useful to count ahead based on work-days (Monday-Friday) instead of all 7 days of the week… The syntax for WORKDAY is as follows: input is optional, but lets you disqualify specific days (like Thanksgiving or Christmas, for example), which might otherwise fall during the work week.(Note that the function strips the time portion of the date.) For newer versions of Excel (2010 and later), there is another version of WORKDAY called WORKDAY. Serial numbers don’t make it easy to extract months, years, and days, nevermind hours, minutes, and seconds.