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

"Mike H" wrote:

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

"Qazi Ahmad" wrote:

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