Hi,
By the if dialog box, I meant the box that opens when i click fx in the task
bar. If I knew how, I would upload a screenprint.


I subscribe to your confusion. Have a nice weekend, I will be back on Monday.
KG, Eucalypta

A smile will carry you around the world


"FSt1" wrote:

hi
i just read down a list of available dialog boxes(258. vb help claims there
ar 794) and i didn't see a "if dialog" box. could you elaborate?

I'm confused. the formula work in tests and you claim it's working for you.
so i don't understand this "invalid" part.

regards
FSt1

"Eucalypta" wrote:

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.