Need to set date to 12/31 of the year of another cell's entry

edited 01/19/23 in Formulas and Functions

Example: column A, "Awarded Date" is 5/1/22. (Yes, it is set as the Date type.)

I want column B, "Expiration Date" to be 12/31/22. How do I parse for the year 22 from column A to create an entry that shows 12/31/22?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!