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

  • Thread starter Thread starter Z-Man-Cek
  • Start date Start date
Z

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?
 
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
 
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
 
Back
Top