Separate Auto Text into New Cell

bmarie320

The date is automatic: 03/21/23 2:16 PM (Cell formatted as Created By).

I need a column that just presents the year of that created by date. I'd like "2023" to be in the circled cells.

Peggy Parchert

@bmarie320

Try =YEAR([Request Date]@row

Hope this helps.

Peggy

Peggy Parchert

@bmarie320

Try =YEAR([Request Date]@row

Hope this helps.

Peggy

bmarie320

Worked perfectly! Thanks Peggy!

Have a great day!

bmarie320

Peggy Parchert

@bmarie320 - you too! Happy to help!