IF & TODAY() formula

[noremac]

Hi

I am trying to create an IF formula that contains a TODAY() formula.

this is the formula =IF(TODAY()>G5," OVERDUE ",IF(AD5="Yes"," No "," OVERDUE "))

I have a spreadsheet that I need to know if something is overdue.

Cell G5 is a date that is 21 days after the received date. Cell AD5 is if it has been approved.

I want my cell to show if the current date TODAY() is greater than G5 I want it to show "OVERDUE" but if Yes has been selected in AD5 (which is a drop down list) then I want it to show "No"

Not sure if that make sense but any help is greatly appreciated.

 

[Scott Huish]

It's not clear what you want it to say if it is not OVERDUE, or if something other than Yes is selected in AD5, I'm assuming the choices are Yes or No.
Also not sure why you are putting spaces around your text results, you can add them back if you need them for some reason.

Is this what you need?

=IF(AND(TODAY()>G5,AD5<>"Yes"),"OVERDUE","NO")

 

[Scott Huish]

If you have a lot of these comparisons, you may want to put =TODAY() in its own cell and then refer to that in the formula as TODAY is a volatile function, which means that if you make any change it has to recalculate this, even if the change does not affect the formula that contains =TODAY().

 

[BAlGaInTl]

Hi

I am trying to create an IF formula that contains a TODAY() formula.

this is the formula =IF(TODAY()>G5," OVERDUE ",IF(AD5="Yes"," No "," OVERDUE "))

I have a spreadsheet that I need to know if something is overdue.

Cell G5 is a date that is 21 days after the received date. Cell AD5 is if it has been approved.

I want my cell to show if the current date TODAY() is greater than G5 I want it to show "OVERDUE" but if Yes has been selected in AD5 (which is a drop down list) then I want it to show "No"

Not sure if that make sense but any help is greatly appreciated.

How about

=IF(AND(TODAY()>G5,AD5<>"Yes"),"OVERDUE","NOT OVERDUE")

 

[noremac]

It's not clear what you want it to say if it is not OVERDUE, or if something other than Yes is selected in AD5, I'm assuming the choices are Yes or No.
Also not sure why you are putting spaces around your text results, you can add them back if you need them for some reason.

Is this what you need?

=IF(AND(TODAY()>G5,AD5<>"Yes"),"OVERDUE","NO")

Thankyou. Worked perfectly.