Hi, I am looking for a formula on excel 2007 to add say 30 days to a date. I am wanting to set up a spreadsheet that when you add the current date it will calculate what the date will be when 30 days has passed or when 60 days has passed. Just business days (Monday thru Friday)
Your looking for the =WORKDAY() function. With your Date in cell A1 = Aug 18, 2015
Number of Days in cell B1 = 30
In cell C1 enter the formula: =WORKDAY(A1,B1)
Cell C1 should be formatted as a Date cell.And, Excel questions are best asked in the Office Software forum.
Yes (14) | ![]() | |
No (14) | ![]() | |
I don't know (15) | ![]() |