Solved I need to add 15 working days to a date an excel sheet

Microsoft Excel 2010 - complete product...
October 24, 2013 at 13:25:14
Specs: Windows 7, ??
So I have a cell with a date 10/24/13 and I need to add 15 working days to that date to determine a deadline how do I do that?

See More: I need to add 15 working days to a date an excel sheet

Report •

#1
October 24, 2013 at 15:23:58
✔ Best Answer
Use the WORKDAY() function:

With your Date in cell A1, try:

=WORKDAY(A1,15,)

See how that works.

EDIT ADDED:

This function is part of the Analysis ToolPak add-in
if you get an error message, make sure you have the
toolpak loaded.


MIKE

http://www.skeptic.com/

message edited by mmcconaghy


Report •

#2
October 31, 2013 at 12:15:44
That worked perfectly and I didn't have to download anything! Thanks!

Report •
Related Solutions


Ask Question