Derive Dates form 3 fields

Detrie Zacharias

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?

Paul Newcome

You could use a helper table or you could use something along the lines of the below.

Start Date:

=DATE([Year Column]@row, [Quarter Column]@row * [Month of Quarter]@row, 1)

End Date:

=IFERROR(DATE([Year Column]@row, [Quarter Column]@row * [Month of Quarter]@row + 1, 1), DATE([Year Column]@row + 1, 1, 1)) - 1