How to auto populate the month and year based on a date mm/dd/yy

Hello, I have a date column (mm/dd/yy) and would like to auto populate the month in a separate column as well as the year in another column. What formula can I use for this? Thank you!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!