Help with =DATE(YEAR(Data),12,31) formula

=DATE(YEAR(Data),12,31) is an excel formula that will populate the last date of the current year into a cell. Tried in SS and it doesn't work...any ideas for how I can get this to work?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!