Excel 2003; using a date in a formula
hi
2 months is about 60 days....put this in Q5...
=IF(AND(B5<(NOW()-60),L5=""),"warning!!!","")
regards
FSt1
"Eucalypta" wrote:
In cel B5 I have a date format; in cel L5 an ordernumber. I want Excel to
warn me if the date is 2 months (or more) later and if cel L5 is empty. this
warning will be shown is a different cell, i.e. Q5.
I am having trouble putting this in a formula or in conditional formatting.
Can anyone help me out? Thanks in advance.
|