Convert numbers into dates for this CY

jmoss1073

I need a formula that converts numbers into dates for this CY. For example, 366 needs to convert to 12/31/2024

Linda Manduchova

Hi @jmoss1073 -

Try the following formula where the "Number Field" column is the one where you store the numbers (in your given example 366).

=[Number Field]@row + DATE(2023, 12, 31)

Linda

Linda Manduchova

Hi @jmoss1073 -

Try the following formula where the "Number Field" column is the one where you store the numbers (in your given example 366).

=[Number Field]@row + DATE(2023, 12, 31)

Linda

jmoss1073

Hi Linda. Thanks much! Works perfectly!