URGENT IF STATEMENT: True if moving between financial year's

  • 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 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 (e-mail address removed)
 
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(B2>A2,"Y","N")

Hope this helps.
Andy.

"Ray Everingham"
 
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 REQUIRED:True if moving between financial years? 3
sum a column range basing on financial year. 5
Pivot Table by Financial Year 2
Financial projections - Income statement, bal sheet and cash flows 3
Financial Year Query 1
Calculating Months within a specific period 6
Copying cells between sheets in a workbook 2
Failing IF Statement 2

Back
Top