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 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
-
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! 😊
-
That's worked perfectly!! Thankyou so much
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!