View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Sheeloo Sheeloo is offline
external usenet poster
 
Posts: 793
Default Is there a formular for calendar days

Excel 2007 has NETWORKDAYS function. It takes care of weekends and holidays
your maintain.

"Abi" wrote:

I have a formular that looks at workdays, but it really should look at
calendar days. Is there a way to include that in my current formular below?

=IF(AND(O7<"(Tom)";R7="(Tom)");WORKDAY(O7;10;O7); "")