Curreny Year Checkbox
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)
Best Answer

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 noncalendar year (e.g. July to June) then another formula would be required.
Hope this helps; if you've any questions etc. then just ask! 😊
Answers

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 noncalendar year (e.g. July to June) then another formula would be required.
Hope this helps; if you've any questions etc. then just ask! 😊

That's worked perfectly!! Thankyou so much
Help Article Resources
Categories
Check out the Formula Handbook template!