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

  • Thread starter Thread starter Ray Everingham
  • Start date Start date
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 (e-mail address removed)
 
See answer in excel.misc and please don't multipost.
Andy.

"Ray Everingham"
 
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?
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

URGENT IF STATEMENT: True if moving between financial year's 1
Simple IF problem 7
Dates in a Financial Year 8
Copy Paste Financial Years 3
IF statement 11
Financial Year Query 1
year function and financial years 5
How do I get Excel to display which financial year a date is in? 6

Back
Top