View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Z-Man-Cek Z-Man-Cek is offline
external usenet poster
 
Posts: 3
Default 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