How to convert lambs into financial year based on months of birth

[GVN KUMAR]

How to convert lambs into financial year according to birth months

You can write an excel formula for each batch of lambs to be arranged from April 1 to March 31 for the financial year.

 

[GVN KUMAR]

How to arrange dates according to financial year​

 

[p45cal]

See pivot table on sheet Sheet2 and formulae in columns B & C
I've manually added and highlighted 3 dates to verify they're put in the right financial year.

 

[GVN KUMAR]

sir
good idea good suggest sir
I am thinking formula but your suggestion also enough sir

thank you sir

 

[p45cal]

Another method; after changing the source data in column A (making sure it remains part of the table), right-click the table at cell C1 and choose Refresh.

 

[GVN KUMAR]

yes sir
thank you sir

 

[p45cal]

I am thinking formula

3 formulae in the attached:
B2:
=YEAR(EDATE(A2,-3))&"-"&TEXT(EDATE(A2,9),"yy")
copied down as far as needed

D1:
=TRANSPOSE(SORT(UNIQUE(B2:B27)))
should spill horizontally

D2:
=SORT(FILTER($A$2:$A$27,$B$2:$B$27=D$1))
copied across as far as needed

 

[GVN KUMAR]

sir
Spare your valuable time for us and give us 2 types of suggestions.
I appreciate your xls knowledge and wisdom in rewriting it for us in formula form.
thank you a lot