Using Date Function & Referencing Other Cells

Tim Dollmeyer
Tim Dollmeyer ✭✭✭✭
edited 12/03/21 in Formulas and Functions

Hello,

I'm trying to create a date using the Date function so I can use it in a formula. Is there a way to use the Date function using cell references instead of numerals? The syntax I'm trying (and failing) to use is something like =Date(Year@row, Month@row, 1).

Thanks!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!