View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.misc
Qazi Ahmad Qazi Ahmad is offline
external usenet poster
 
Posts: 32
Default Future date Calculation

Thank you Mr. David to help me it solve my Prblem
Thank you very much


"David Biddulph" wrote:

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