Use a YEAR column to autofill a date

Amelia Retureta

Hi,

I'm hoping to use a formula to take a YEAR DUE and return a date of 1/1/XX for the NEXT ASSIGNED DATE. I tried my best to sleuth it out but came up empty. Any help would be much appreciated.

Thanks!

Kimberly Loveless

Hi @Amelia Retureta I understand you are always looking for this to return January 1st of the year entered so you should be able to us the Date formula

=DATE([Year Due]@row, 1, 1)

Kimberly Loveless

Hi @Amelia Retureta I understand you are always looking for this to return January 1st of the year entered so you should be able to us the Date formula

=DATE([Year Due]@row, 1, 1)

Amelia Retureta

Hi @Kimberly Loveless,

That did it. Thanks so much!