# Curreny Year Checkbox

Options
✭✭

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

• ✭✭✭✭✭✭
Answer ✓
Options

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! 😊

## Answers

• ✭✭✭✭✭✭
Answer ✓
Options

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! 😊

• ✭✭
Options

That's worked perfectly!! Thankyou so much

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!