See answer in excel.misc and please don't multipost.
Andy.

"Ray Everingham"
<Ray.Everingham.28en1m_1148630102.5486@excelforu m-nospam.com wrote in
message news:Ray.Everingham.28en1m_1148630102.5486@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=545760