Formula to atribute value on a cell, based on the date present on other cell

[rioxrenato]

Hi, I need some help with a formula, I tried using =IF(H2>=DATE.VALUE("01/08/2022"),"CORRENTE","PASSIVO") but could not make it work, I want to, on a column, give "CORRENTE" OR "PASSIVO" based on the dates on another column... I anexxed a screenshot of the sheet I'm working with, the dates are on H column, the one I want to use the formula is K

 

[SanjayGMusafir]

Hi, I need some help with a formula, I tried using =IF(H2>=DATE.VALUE("01/08/2022"),"CORRENTE","PASSIVO") but could not make it work, I want to, on a column, give "CORRENTE" OR "PASSIVO" based on the dates on another column... I anexxed a screenshot of the sheet I'm working with, the dates are on H column, the one I want to use the formula is K

Try this

=IF(H2>=DATEVALUE("01/08/2022"),"CORRENTE","PASSIVO")

 

[Fluff]

Hi & welcome to MrExcel.
If you are using a Portuguese language version the you need to use

=SE(H2>=DATA.VALOR("01/08/2022");"CORRENTE";"PASSIVO")