View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default 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.