How can I put an ultimatum into the excel database?
R Roger Govier Oct 26, 2005 #2 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
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
M Mladen_Dj Oct 26, 2005 #3 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.
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.
