Future date Calculation

[Guest]

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

 

[Guest]

If i understand correctly:-

A1 = Today()
B1= 30/5/2007
c1= 31/12/2007

Put this formula in D1 and format as general

=MAX(B1,C1)-A1

Mike

 

[Niek Otten]

=B1-A1 and format as General, not as Date, which Excel does automatically.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| 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

 

[Guest]

t= datedif(first_date,Second Date,"d")
datedif() is not described in Help
or
just subtract the cells with the dates
excel increments its dates record by 1 per day.
if you need workdays only
try
=networkdays(first date,second date)
you need to have the analysis toolpack add-in for this one

 

[David Biddulph]

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.

 

[Guest]

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

 

[Guest]

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

 

[Guest]

Thank your Mr. Niek to help me it solve my Prblem very simple and helpful
Answer
Thank you very much

 

[Guest]

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