View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
LSG LSG is offline
external usenet poster
 
Posts: 16
Default Calculate the number of days to exclude Sunday & Holidays

I need to know what the third business day from a Manually entered date in
Cell B37 to exclude Sundays and Holidays. So far I have:

=WORKDAY(B37,3,Holidays)

But I realized that I need it include Sat. and this formula won't do that.
Any suggestions?

THANKS!

--
-Liz