This is a two-parter.
Part 1: I have a dropdown field where users select a month and year in the format of Jan-2021, Apr-2022, where it is always a 3 character month followed by 4 character year. I need to return the date that is the last Sunday of the month that is selected in that drop-down. Any ideas on how to do that? I can use helper columns but just can't figure out how to get there.
Part 2: Once I get that date that is the last Sunday of the month, I then need to calculate another date that is either 3 months or 6 months from that date. I need to do it by increasing the month of the date by 3 or 6. I've figured out that I can use the formula =DATE(YEAR([Test Date]@row) + 1, MONTH([Test Date]@row), DAY([Test Date]@row)) to get the date that is 12 months away, but when I try to do the same for the month in this formula I get an error if the resulting date goes into the next year.
