Formula for TaxYear from Date

[haider378]

Salam To All,

I need a formula to show tax_Year from date column, my assumption is that Taxyear start from July and end on June of every year i,e

Date Tax_Year
1-Jul-2016 2016-17
1-Aug-2016 2016-17
30-Dec-2016 2016-17
30-June-2017 2016-17
30-Jul-2017 2017-18

 

[StephenCrump]

Try: =YEAR(A1+184)-1&"-"&RIGHT(YEAR(A1+184),2)

 

[r1998]

Salam and welcome haider378
data from a1 to a5 is

01-Jul-16
01-Aug-16
30-Dec-16
30-Jun-17
30-Jul-17

in b1 use this formula n drag down till b5

=IF(MONTH(A1)>=7,YEAR(A1)&"-"&RIGHT(YEAR(A1)+1,2),YEAR(A1)-1&"-"&RIGHT(YEAR(A1),2))

 

[haider378]

Salam and welcome haider378
data from a1 to a5 is

01-Jul-16
01-Aug-16
30-Dec-16
30-Jun-17
30-Jul-17

in b1 use this formula n drag down till b5

=IF(MONTH(A1)>=7,YEAR(A1)&"-"&RIGHT(YEAR(A1)+1,2),YEAR(A1)-1&"-"&RIGHT(YEAR(A1),2))

Thanks for your reply, It works
I tried this one also

=IF(MONTH(A2)>=7,YEAR(A2)&"-"&YEAR(A2)+1,YEAR(A2)-1&"-"&YEAR(A2))

 

[r1998]

Thanks

 

[MARK858]

@haider378, did the formula StephenCrump posted in post number 2 not work for you (obviously changing A1 to A2 as it looks like you have headers)?