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

[Guest]

How can I put an ultimatum into the excel database?

 

[Roger Govier]

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

 

[Mladen_Dj]

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.