PDA

View Full Version : Excel formula question....

danielhv
02-03-2005, 08:04 PM
Ok, i have 2 dates... the date and article was mailed, and the date it was recieved by the recipient. They have 30 days to respond... How can I have excel countdown how many days they have left to respond?

Daniel
Hunt4m3x
02-03-2005, 08:24 PM
Get on aim. Send me the file/
01WhiteCobra
02-03-2005, 08:40 PM
If the date you are calculating the 30 days from is in A1 put this formula:

=A1+30-TODAY() & " days remaining"

in the cell you want to display the days remaining. Assumption: A1 is formatted as date.

Obviously adjust A1 to whatever cell you are calculating from. If you are doing the entire column use $A1 and you can paste the formula on down the column.