if(and) formula

[mikeywhits]

Hi Guys,


I am trying to do and if(and) formula which will place an "R" for if the date in cell a1 has either passed or is due in the next 14 days, AND is cell B1 is "Open", based on the computers internal clock.

Thanks.

Mike

 

[VoG]

Try

=IF(AND(A1-TODAY()<14,B1="Open"),"R","")

 

[mikeywhits]

Thanks Vog

 

[mikeywhits]

Hi Vog,

Can this formula return a blank response if there is no date in cell a1?

Thanks

Mike

 

[VoG]

Try

=IF(A1="","",IF(AND(A1-TODAY()<14,B1="Open"),"R",""))