Welcome!

Formula for finding the first and last days of a year

I need to be able to calculate the first and last days of the year based upon the current date. Can someone help me out?

Formulas

You don't really need to update anything other than the year right?

=date(year(today()),1,1) is the first day of the year

=date(year(today()),12,31) is the last day of the year

Correct,

Perfect, Thank you!

How to determine the last two lines of a sheet when row is checked
I'm trying to find and number in the Rank column the last two rows that have a status column with a check in the checkbox. I am using the following formula but am getting a #INVALID OPERATION error. =IF(AND(Status@row = 1, [Row #]@row >= LARGE(COLLECT([Row #]:[Row #], Status:Status, 1), 2)), 1, 0) The properties for each…
Protect formulas within cells in a single column without using column formula or locking the column
Objective: Status column is a drop-down. The cells in the Status column have a formula using Descendants, with the idea that when the descendants tasks are all marked with the same status, such as "Completed," then the ancestor to those descendants is also auto-marked as "Completed." Example: See screenshot below. When…
How do I display the username of a modifier of a specific column?
I am attempting to display the username of a specific column using an automation workflow. I want for a user to be able to scan a barcode into column A, and for their credentials and time/ date of the barcode scan to be displayed in the next two columns. However, I want the credentials and time to be displayed of the user…