Dates in excel

  • Thread starter Thread starter maggie castillo
  • Start date Start date
M

maggie castillo

I need your help on the following matter:

If I'm working on excel, and I need to get an especific
date starting today but without considering Saturdays and
Sundays....for example:

Today= Friday February 06,03 + 5 days, my date should be
Thursday February 12

Which should be the right formula ?

Thanks in advance for all your support.

Best Regards,

Maggie
 
I need your help on the following matter:

If I'm working on excel, and I need to get an especific
date starting today but without considering Saturdays and
Sundays....for example:

Today= Friday February 06,03 + 5 days, my date should be
Thursday February 12

Which should be the right formula ?
Click to expand...


Look at NETWORKDAYS in HELP.


--ron
 
Try

=WORKDAY(A1,5,Holidays)

the above function is part of the Analysis ToolPak (ATP) and if you get
a name error do tools>add-ins and check it, keep the CD handy and follow the
instructions
Holidays can be a name range (as in my example) with the public holidays or
just a range
with them as in

=WORKDAY(A1,5,H2:H12)

anyway the above will return 02/13/03 (Thursday)
 
-----Original Message-----
I need your help on the following matter:

If I'm working on excel, and I need to get an especific
date starting today but without considering Saturdays and
Sundays....for example:

Today= Friday February 06,03 + 5 days, my date should be
Thursday February 12

Which should be the right formula ?

Thanks in advance for all your support.

Best Regards,

Maggie
Click to expand...

Start Work days Due Date
01/02/03 5 07/02/03

formula in c2.
IF(NETWORKDAYS(A2,A2+B2)<B2,A2+2*B2-NETWORKDAYS
(A2,A2+B2),A2+B2)

Regards
Peter
 
Look at NETWORKDAYS in HELP.


--ron
Click to expand...


Oops, that should be the WORKDAYS formula.

However, if you are not US based, let me know, as WORKDAYS is US-centric.


--ron
 
Back
Top