How can I put an ultimatum into the excel database?

Example: putting a date ( 01 25 06 ) and today's date ( 10 26 05 )
and get an ultimatum by substraction of them ( date - today's date )
to get a cell which makes appear how many days are left????

Can you help me ?? Is it possible?

Hi

With your date entered in cell A1, as a valid Excel date e.g. 01/25/06 then
in another cell
=IF(A1<=TODAY(),"",A1-TODAY())

or
=IF(DATE(2006,1,25)<=TODAY(),"",DATE(2006,1,25)-TODAY())

Regards

Roger Govier


liliandelosnarcos wrote:
How can I put an ultimatum into the excel database?

Example: putting a date ( 01 25 06 ) and today's date ( 10 26 05 )
and get an ultimatum by substraction of them ( date - today's date )
to get a cell which makes appear how many days are left????

Can you help me ?? Is it possible?

You enter ultimatum/deadline date in cell for example E1, and in F1 cell put
formula:

=E1-TODAY()

In F1 use General Number format, and result is number of days until
ultimatum/deadline.


"liliandelosnarcos" wrote in
message ...
How can I put an ultimatum into the excel database?

Example: putting a date ( 01 25 06 ) and today's date ( 10 26 05 )
and get an ultimatum by substraction of them ( date - today's date )
to get a cell which makes appear how many days are left????

Can you help me ?? Is it possible?