Useful date functions in Excel
Use today() function to get current date in ExcelHow do I determine a date that is 50 workdays after another date? What if I want to exclude holidays?
The function WORKDAY(start_date,#days,[holidays]) displays the date that is the number of workdays (a workday is a nonweekend day) indicated by #days after a given start date.
Post a Comment