Help with IF formula

Admin

I want to enter a value in Column155 when Asbestos Awareness column is "Passed" and Asbestos Awareness Completion Date column is in the current year.

I have tried the following formula which returns blank not 0:30 on current year

=IF([Asbestos Awareness Completion Date]@row = "TODAY()", "0:30", IF([Asbestos Awareness Completion Date]@row = "Passed", "0:30", ""))

Admin

Sorry "TODAY()" should say "YEAR()"

VBAGuru

You may try something like

=IF(AND(YEAR([Asbestos Awareness Completion Date]@row) = YEAR(TODAY()), [Asbestos Awareness Completion Date]@row = "Passed"), "0:30", "")

Admin

This returns Incorrect Argument unfortunately.

Paul Newcome

Is your completion date column definitely set as a date type column? If so, how exactly is it being populated?

Admin

Yes definitely a Date Type Column and date is entered manually.

Admin

I've just tried it again and it is working although the I am getting invalid data type in blank columns

Paul Newcome

Start it with an IF statement:

=IF([Date column name]@row <> "", IF(AND(………..)))