Convert ddmmyy to Customise Qtr Yr

[dessim]

Hi ppl,

Previously I made enquires abt converting DDMMYY to Qtr YY.

Example 15012019 = Qtr1 19

But now due to some requirement in company, my Qtr1 can only starts on April 2019

Meaning from April, May, June 19 = Qtr1 19
July,Aug, Sept 19 = Qtr 2 19
Oct, Nov, Dec 19 = Qtr 3 19
Jan 20, Feb20, March20 = Qtr 4 19

With such requirement on above, may i know how to I get the desired output:

example 25th May 19 = Qtr1 19
10th July 19 = Qtr2 19


Do I need some sort of VB code to achived the desired outcome ?

Seek some kind advise .

Thank you very much.

 

[SupremeDr]

Without seeing the previous resolution there might be 2 option.

1. is an if statement =IF(A1 is between dates, "Qtr1 19", IF(A1 is between dates, "Qtr 2 19", Etc.....
2. see if you can simply subtract from your current solution.

 

[Finalfight40]

If you are looking for a formula solution, maybe you can try:

REMOVED AS NEEDED TO EDIT

 

[SupremeDr]

This might be simplest

="Qtr " & ROUNDUP(MONTH(A1)/3,0)-1

 

[Finalfight40]

Updated:

="Qtr" & CHOOSE(ROUNDUP(MONTH(A1)/3, 0), 4, 1, 2, 3) & " " & RIGHT(YEAR(A1), 2) - IF(MONTH(A1)<4, 1, 0)

or

="Qtr" & MOD(ROUNDUP(MONTH(A1)/3, 0)+2, 4)+1 & " " & RIGHT(YEAR(A1), 2) - IF(MONTH(A1)<4, 1, 0)