Derive Dates form 3 fields

Options

I have 3 columns I want to use to derive month start and end dates

Year

Quarter

Month of the quarter

EXAMPLE:

Year = 2020

Quarter = 3

Month of quarter = 2

Start Date= 08/01/2020 and End Date = 08/31/2020


Maybe use a helper table and VLOOKUP?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!