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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Hi
try
=WORKDAY(A1,A2)
if A1 is your start date and A2 the number of working day to add
 
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.
ls30819 said:
I am trying to find a formula to enter a date then add 3 days to
Click to expand...
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
Click to expand...
saturday and sundays date. Can anyone give me the correct formula to
use.
 
Back
Top