View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default Future date Calculation

If you have 30/5/2007 in A2, and 31/12/2007 in A3, then the number of days
from today until the later of those two dates
=MAX(A2,A3)-TODAY()
and format as number or general.
--
David Biddulph

"Qazi Ahmad" wrote in message
...
My one cell have today date with formula =Today() and i want total
remaining
day in Numbers from any given future date. Exp. I put in one cell
30/5/2007
other cell have 31/12/2007 and the result should be show in numbers how
many
remaining day from today to till last day of give future date.
Thank you