Convert numbers into dates for this CY

jmoss1073 ✭

02/15/24 in Formulas and Functions

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

0 · Share on FacebookShare on Twitter

Best Answer

• 

  Linda Manduchova ✭✭✭✭

  02/15/24 Answer ✓

  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

  1 · Share on FacebookShare on Twitter

Answers

• 

  Linda Manduchova ✭✭✭✭

  02/15/24 Answer ✓

  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

  1 · Share on FacebookShare on Twitter
• 

  jmoss1073 ✭

  02/15/24

  Hi Linda. Thanks much! Works perfectly!

  0 · Share on FacebookShare on Twitter

Sign in

Try Smartsheet

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list