Is there a formular for calendar days

[Abi]

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);"")

 

[Bernie Deitrick]

Abi,

Instead of

WORKDAY(O7,10,O7)

use

O7+10

Dates are just numbers - one day is 1, so adding ten adds ten days - hours are the decimal values,
where 6 hours = .25 for example....

HTH,
Bernie
MS Excel MVP

 

[Sheeloo]

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