Date formulas (date + no of days to return date mon-dri only)

[ls30819]

I am trying to find a formula to enter a date then add 3 days to return a working day date (not sat or sun) eg:

date no of days to add
3/3/04 3
4/3/04 3

I need the results to be 8/3/04 but doesn't matter what I do I get saturday and sundays date. Can anyone give me the correct formula to use.

 

[Frank Kabel]

Hi
try
=WORKDAY(A1,A2)
if A1 is your start date and A2 the number of working day to add

 

[Norman Harker]

Hi!

Use:

WORKDAYS(A1,B1)

Where A1 contains the date and B1 the number of working days to add.

This is an Analysis ToolPak function.

See Help for adjusting for holidays and if you get a return of #NAME!
--
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.

I am trying to find a formula to enter a date then add 3 days to

return a working day date (not sat or sun) eg:

date no of days to add
3/3/04 3
4/3/04 3

I need the results to be 8/3/04 but doesn't matter what I do I get

saturday and sundays date. Can anyone give me the correct formula to
use.