How do I create a formula to pull the year from a date from every row in a column?

kelsey_odoc

Hello! I am very new to formulas, and I'm having a hard time figuring them out. I want to create an automatic function that will pull the year (and separately, the month) into a new cell, so that I can break down my sheet into year, and then month, with collapsible rows.

Basically, I have a row titled "Date of Employee Request". I need a formula to pull the year from every row in this column into a new column titled "Year" and to automatically keep pulling it as new rows are added. I'm certain this can be done, but all my attempts to make it work have failed.

I appreciate any help or insight.

Thank you! 😊

JamesB

@kelsey_odoc Use the formula's below in your month and year columns and make them column formulas. These will be Text/Number columns.

=YEAR([Date of Employee Request]@row)

=MONTH([Date of Employee Request]@row)