Click here for important information about Computing.net.

Solved How to calculate formula

August 18, 2015 at 08:23:00
Specs: Macintosh
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)

See More: How to calculate formula

Report •

#1
August 18, 2015 at 08:39:50
✔ Best Answer
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.

MIKE

http://www.skeptic.com/


Report •
Start a discussion
Related Solutions
See More ↓


Ask Question