if formula returns a weekend - move it forward to next weekday
 

Hi Friends,

I need a formula to look at a date and return a date 2 days later - easy,
right? Of course, but I also need it to ignore weekends and holidays and
only propose weekdays. I think I need to use the NetWorkingDays, but I don't
know how to apply it to a single cell reference like this. Can you help?
--
Z-Man

if formula returns a weekend - move it forward to next weekday
 

Hi Z-Man,

You need the WORKDAY() function instead.


--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Z-Man-Cek" wrote in message ...
| Hi Friends,
|
| I need a formula to look at a date and return a date 2 days later - easy,
| right? Of course, but I also need it to ignore weekends and holidays and
| only propose weekdays. I think I need to use the NetWorkingDays, but I don't
| know how to apply it to a single cell reference like this. Can you help?
| --
| Z-Man

if formula returns a weekend - move it forward to next weekday
 

You want to use the WORKDAY function which requires the Analysis Toolpak
add-in be installed.

A1 = date
H1:H10 = list of holiday dates

=WORKDAY(A1,2,H1:H10)

Format as DATE

--
Biff
Microsoft Excel MVP


"Z-Man-Cek" wrote in message
...
Hi Friends,

I need a formula to look at a date and return a date 2 days later - easy,
right? Of course, but I also need it to ignore weekends and holidays and
only propose weekdays. I think I need to use the NetWorkingDays, but I
don't
know how to apply it to a single cell reference like this. Can you help?
--
Z-Man