View Single Post
  #1   Report Post  
AG
 
Posts: n/a
Default calculate day for day

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.