If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)

Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

Excel > and< than with dates?

PC CDROM · 2012-05-31 22:10:09

Hi, As well as I know excel I am struggling with the following. in A I have dates. What I am trying to say is: if A(date) is >= 01/04/2012 but <= 31/03/2013, then FY13, else if A(date) is >= 01/04/2011 but <= 31/03/2012, then FY12) otherwise "NA" The whole =if(and( thing is just not working for me :( Help?

Options

31-05-2012 11:10pm

#1

PC CDROM

Closed Accounts Posts: 408 ✭✭

Join Date: May 2012

Posts: 377

Hi,

As well as I know excel I am struggling with the following.

in A I have dates. What I am trying to say is:

if A(date) is >= 01/04/2012 but <= 31/03/2013, then FY13, else if A(date) is >= 01/04/2011 but <= 31/03/2012, then FY12) otherwise "NA"

The whole =if(and( thing is just not working for me

Help?

0

Comments

Options
#2 31-05-2012 11:23pm
jabberwock

Registered Users Posts: 928 ✭✭✭

Join Date: December 2002

Posts: 845

this is what you are trying to do i think

0