Curreny Year Checkbox

KatieB

Please help.

I have been using this formula to check a box if the date the employee left is the current year but it is still only counting 2022 and i need it to be the current year..

=IF(YEAR(TODAY() - DAY(TODAY())) = YEAR([Last Day of Employment]@row), 1, 0)

Nick Korna

Hi @Katie B

I'm not sure why you have the DAY portion of your formula; if you're after only current year showing then the following should work:

=IF(YEAR(TODAY()) = YEAR([Last Day of Employment]@row), 1, 0)

If you had a non-calendar year (e.g. July to June) then another formula would be required.

Hope this helps; if you've any questions etc. then just ask! 😊

Nick Korna

Hi @Katie B

I'm not sure why you have the DAY portion of your formula; if you're after only current year showing then the following should work:

=IF(YEAR(TODAY()) = YEAR([Last Day of Employment]@row), 1, 0)

If you had a non-calendar year (e.g. July to June) then another formula would be required.

Hope this helps; if you've any questions etc. then just ask! 😊

KatieB

That's worked perfectly!! Thankyou so much