Adding numbers to dates

[Enigmatic]

I'm trying to count 25 *weekdays* out. Simply adding 25 to March 11,
2004 gives me April 5, 2005 (which includes weekends). Using the
Edit/Fill/Series/Weekday gives me what I need (April 15th, 2004) but I
need a formula.

Can anyone help?

 

[Norman Harker]

Hi Enigmatic!

Use:

=WORKDAY(A1,25)

Adds 25 working days to the date in A1.

There is a third argument

=WORKDAY(start_date,days,holidays)

Where holidays is an optional range of one or more dates to exclude
from the working calendar. The list can be either a range of cells
that contains the dates or an array constant of the serial numbers
that represent the dates. Named ranges must be used if range is on a
different sheet.

WORKDAY is an Analysis ToolPak function.

If the above formula returns #NAME! use Tools > Addins and check
Analysis ToolPak

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[JE McGimpsey]

Look for the WORKDAY() function in XL Help.

It's part of the Analysis Toolpak Add-in (Tools/Addins...)

 

[Et3rnal]

Do you want this 25 days to be added on the date of opening? There for
changing every time you open it