Date in formula

[Eucalypta]

Dear readers,

Cel B4 contains a date (format 11-01-08), Cel L4 contains order#, Cel Q4
contains formula =IF(AND(B4>NOW()-60);L4="";"Alarm!!!")

I was trying to get the word Alarm if the date in B4 is at least today+2
months. The formula returns a value TRUE. I want the cel Q4 to be empty as
long as the
condition is not met. Can anyone please tell me how to let Excel know what I
want? Thanks in advance.
--

 

[Nigel]

=IF(AND(B4>NOW()-60,L4=""),"Alarm!!!","")

 

[Niek Otten]

=IF(AND(B4>NOW()+60,L4=""),"Alarm!!!","")

Gives alarm if B4 is more than 60 days later than today and L4 is empty. If you meant L4 not empty, change L4="" to L4<>""

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Dear readers,
|
| Cel B4 contains a date (format 11-01-08), Cel L4 contains order#, Cel Q4
| contains formula =IF(AND(B4>NOW()-60);L4="";"Alarm!!!")
|
| I was trying to get the word Alarm if the date in B4 is at least today+2
| months. The formula returns a value TRUE. I want the cel Q4 to be empty as
| long as the
| condition is not met. Can anyone please tell me how to let Excel know what I
| want? Thanks in advance.
| --
|

 

[Eucalypta]

Hi Niek,

Thanks for the response. I indeed want the Alarm when L4 is empty.
KG, Eucalypta

 

[Eucalypta]

Hi Nigel,

thank you for your kind response.

KG, Eucalypta