Sign in to join the conversation:
Hi
Need to determine how many days in the current year (365 or 366) to be used in a calculation. Can anyway suggest how to determine how many days in the current year?
Cheers
Simon
There are a few ways do do this. The most straightforward being
=YEARDAY(DATE(2019, 12, 31))
This will give you the year day (1 - 365 or 366) for whatever date you specify. In this case it would be the last day of the year.
You can automate the date to look at this year, next year, previous year, etc, you can leave it as manual entry within the formula, or you can use various options for cell referencing to change the entire date or the year, or many other possibilities.
Or, if you just want a simple Yes/No (is this year a leap year), divide the current year by 4, then compare that to the integer version.
"Int(currentYear/4)=currentYear/4" should return a True/False matching "Is this year a leap year"
Thanks Paul and Corey, based on your input i used the below:
=YEARDAY(DATE(YEAR([Due Date]1), 12, 31)) = 365 or 366
Provides number of days in year, based on the date contained in another cell [Due Date].
Excellent Use. Happy to help!
My reminder in smartsheet automation is set to trigger every day starting 12/05/2025 at 8am (gmt+1) and the condition is to send the reminder to the contact in the contact list if the reminder flag is set to 1 and the status is not one of DONE. Currently on the sheet, a task has the reminder flag set to 1 and the status is…
I am attempted to export to excel. I have two different smartsheet documents to export. One of them exported to excel fine, but not the other. This happened a few weeks ago. I make sure all columns were the correct size & no cells were hidden. "We have found a problem with (file) Do you want us to try and recover as much…
Hi Everyone, My IT has a lot of confusion on what we access we really need to have for certain people. What is the difference between a "Member" and a "Licensed User?" We have a lot of sheets that have owners who do all of the changes of the sheet. I know that they need to be licensed users. But then, we have a lot of…
