URGENT IF STATEMENT REQUIRED:True if moving between financial years?

R

Ray Everingham

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

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

Appreciate you help.

Please email me at [email protected]
 
A

aidan.heritage

Not sure how one date moves anywhere, so it may be difficult to answer
the question, BUT why not have the start/finish dates of the financial
year on 2 cells in the workbook and reference these?
 
R

Ray Everingham

Sorry about multiposting. My first time here.

The situation I have is that I have one date in cell A1 and anothe
date in cell A2. What I am trying to find out is first, if there is
logical or financial function that will return TRUE if the financia
year in cell B2 has moved on a year. For example, A1=01/05/06, B1
01/04/07, Answer=TRUE.

I do apologise if this is a question that has been asked a thousan
times before. If you can direct me to where I can find the answer in
FAQ then great
 
Top