how to write fiscal year half H1,H2 condition?

[balasundaram]

i want above condition

[ajaykumar1]

Try like;

If your getting the years like April 13......Mar 14 in fiscal year

Then try like below;

If(wildmatch(fiscal year,'April','May','Jun','July','aug','sept'),H1,'fiscal year) as fiscal year_bifurcation.

Regards,

Ajay