Change formula to perform different calc based on date in another cell

[boznian]

Hi- Current formula is an easy
=IF(F6,(G6*$H$2),"")
Need to change it to
=IF(F6,(*check date value in F6; if prior to 02/01/2018 then (G6*".6"), if after 02/01/2018 then (G6*$H$2),"")

Can someone help me with this? thx!

 

[Joe4]

Try:

=IF(F6,IF(F6 < DATE(2018,2,1),G6*0.6,G6*$H$2),"")

<date(2018,2,1),g6*.6,g6*$h$2),"")[ code]<="" html=""></date(2018,2,1),g6*.6,g6*$h$2),"")[>

 

[boznian]

Jeez you gotta love this place! Thanks Joe!!

 

[Joe4]

You are welcome!