Excel help

i want to subtract multiple DATE cells to me days

how do i do it?

You wanna go on multiple Dates  ?  hocked:

Lemme see IF  I can write a macro for that ..

2/16/2012, 2/17/2012, 2/18/2012, 2/19/2012
Set the date in the column like the above and then  insert your formula accordingly but make sure that you set the criteria as date and number accordingly

Subs , she trying to reset February 29 th  :

Leap Years are a Biatch !  ::lol::

she need a time machine to do that  ::redcard::

that doesnt work

i dont get days even if i change the cell format

i am almost thinking it cant be done

then something is wrong with your excel setting (might be corrupted). because it should work once you change the format in the cells.

no it doesnt

i am trying to subtract a date from April, from a date in March, from 3 dates in Feb

to give me the remaining days

Add  1 day for a Leap Year ..

leap year doesnt matter