What separator do your windows regional settings call for? Is it looking
for semi-colons instead of commas?
--
David Biddulph

"Eucalypta" wrote in message
...
Hi,
Thanks for the formula. At first glance Excel does not have any problems
with it and it returns with the warning. However, when I open the
IF-dialog
box Excel tells me the formula is invalid.
KG, Eucalypta
--
A smile will carry you around the world


"FSt1" wrote:

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.