Hi Team,
I have created one userform if user select Q1 from ComboBox
I should get first Quarter end Date of Current year. 30/06/2021
if user select second Q2 I should get 2nd Quarter end Date 30/09/2021
my quarters start from Apr-Jun, Onward. User download Previous quarters Result.
Below is table. Expected output is in Column B.
Thanks
mg
Thanks
mg
I have created one userform if user select Q1 from ComboBox
I should get first Quarter end Date of Current year. 30/06/2021
if user select second Q2 I should get 2nd Quarter end Date 30/09/2021
my quarters start from Apr-Jun, Onward. User download Previous quarters Result.
Below is table. Expected output is in Column B.
Quarter | Last_Quarter_Date | Quarter Begins |
Q1 | 30/06/2021 | Apr-Jun |
Q2 | 30/09/2021 | July-Sep |
Q3 | 31/12/2021 | Oct-Dec |
Q4 | 31/03/2020 | Jan-Mar |
Thanks
mg
Thanks
mg