Hi
Try something like this:
=((C8-C7)+AND(C70,C80))*(AND(C70,C80))

--
Andy.


"AG" wrote in message
...
I need a formula to calculate day for day for a 365 year. The only
function
I can find in excel is days360.

For example: If I took a vacation from 1 mar 04 thru 10 mar 04 that would
be 10 days. Which I can do with SUM +1 but if the cells are blank I need
the
amount of days to be zero (or blank) not 1.