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

[Z-Man-Cek]

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?

 

[Niek Otten]

Hi Z-Man,

You need the WORKDAY() function instead.


--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| 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

 

[T. Valko]

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