I need to comeup with an IF statement, where of a date is moving from
one financial year to another, the output is Y.

I have tried working it out bu working with the financial year as
oppossed to the calander year is causing me problems.

Appreciate you help.

Please email me at


--
Ray Everingham
------------------------------------------------------------------------
Ray Everingham's Profile: http://www.excelforum.com/member.php...o&userid=34822
View this thread: http://www.excelforum.com/showthread...hreadid=545765

Hi
It depends on the layout of your data, but if your year-end date is in A2
and your 'date' is in B2, try this in C2:
=IF(B2A2,"Y","N")

Hope this helps.
Andy.

"Ray Everingham"
<Ray.Everingham.28enqn_1148631001.5859@excelforu m-nospam.com wrote in
message news:Ray.Everingham.28enqn_1148631001.5859@excelfo rum-nospam.com...

I need to comeup with an IF statement, where of a date is moving from
one financial year to another, the output is Y.

I have tried working it out bu working with the financial year as
oppossed to the calander year is causing me problems.

Appreciate you help.

Please email me at


--
Ray Everingham
------------------------------------------------------------------------
Ray Everingham's Profile:
http://www.excelforum.com/member.php...o&userid=34822
View this thread: http://www.excelforum.com/showthread...hreadid=545765