+- Cricket Windies (https://cricketwindies.com)
+-- Forum: What’s on Your Mind? (https://cricketwindies.com/forum-3.html)
+--- Forum: The Water Cooler! (https://cricketwindies.com/forum-4.html)
+--- Thread: Excel help (/thread-4982.html)
Excel help - Nargis - 02-15-2012
i want to subtract multiple DATE cells to me days
how do i do it?
Re: Excel help - ketchim - 02-15-2012
You wanna go on multiple Dates ?
hocked: Lemme see IF I can write a macro for that ..
Re: Excel help - BK - 02-15-2012
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
Re: Excel help - ketchim - 02-15-2012
Subs , she trying to reset February 29 th :
Leap Years are a Biatch ! ::lol::
Re: Excel help - BK - 02-15-2012
she need a time machine to do that ::redcard::
Re: Excel help - Nargis - 02-15-2012
that doesnt work
i dont get days even if i change the cell format
i am almost thinking it cant be done
Re: Excel help - BK - 02-15-2012
then something is wrong with your excel setting (might be corrupted). because it should work once you change the format in the cells.
Re: Excel help - Nargis - 02-15-2012
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
Re: Excel help - ketchim - 02-15-2012
Add 1 day for a Leap Year ..
Re: Excel help - Nargis - 02-15-2012
leap year doesnt matter