Due Dates
Posted by Steve Langford on June 15, 2000 8:42 AM
We are looking for a formula that will look at the calendar dates posted in a field, then enter "Due" in the next field if that date is within the next 30 days.
Thanks
Posted by JAF on June 16, 0100 1:16 AM
I'm not sure if this is what you need, but the following formula will display "Due" if the date in cell A1 is less than or equal to todays date + 30 days, otherwise it will be blank.
=IF(A1<=TODAY()+30,"Due","")
JAF
Posted by Ryan on June 15, 0100 8:56 AM
By field, do you mean a range, or a single cell. Give an example.
Posted by mads on June 15, 0100 1:14 PM
=IF((A1+30)<TODAY(),"Due","")
mads
Mads
Posted by mads on June 15, 0100 1:18 PM
Something went wrong. Should be :-
=IF((A1+30)<TODAY(),"Due","")
Posted by mads on June 15, 0100 1:28 PM
Still not being posted properly. But the Comments box seems to be showing it correctly.
