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
|