how to input an ultimatum in an excel database...
 

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?

how to input an ultimatum in an excel database...
 

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?

how to input an ultimatum in an excel database...
 

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?