![]() The formula also works if you want to compute working days in reverse and arrive at a date that falls a certain number of days before. The return we get is, which is the date that falls 60 working days after. Notice that we supplied the list of holidays separately, while the weekends were factored in by the formula by default. What we are doing in this example is trying to compute the date that falls 60 working days after, provided that there is 1 holiday in December 2001, and 2 in January 2002. We will use the following formula (which is actually just plain addition) to add 31 days to a date: Just for this reason, when you want to add a certain number of days to a date in Excel, you can just put in the number of days you want to add and you will have your output date. Based on the same logic, Dec 25, 2001, corresponds to 37,250 because it is 37,249 days after January 1, 1900. ![]() The serial numbers are assigned such that Januis considered as 1, and thereafter the numbers increment with each day. ![]() There is no magical formula that Excel uses to assign serial numbers to dates, though. We all know that Excel stores dates as serial numbers.
0 Comments
Leave a Reply. |