I am struggling with an Excel formula and wondered if anybody could help me.

I have a column of dates and I need a formula to work out whether the date is ‘in year’ (after 1st August 2010) or ‘out of year’ (after 31st July 2011) and give the response ‘In’ or ‘Out’

Thank you.

=IF(A1>40390,”out”,”in”)

What he said

where [A1] is the cell containing the date, then copy down

NOw can anyone do the analysis of my Q1 forecasts for me and put it into a logical powerpoint presenation?

CM – thank you

**** Southern Yeti, anybody would think I was asking for a logo.

logical powerpoint?
Use Prezi
http://prezi.com

Spacecadett. A more transparent way to do it would be to put your cut off date in a cell, then use the same formula as above, but instead of ‘>40390’ put in the cell reference

Presuming I read the original post correctly I make it =IF(A1>40755,”out”,”in”)

It’s okay I’m on it…. can someone give me a formula that saves £3m in a rational and achievable way?

Presuming I read the original post correctly I make it =IF(A1>40755,”out”,”in”)

oh yeah, wrong year. I guess the date cell would make it less prone to error

Also presuming dates before 1/08/2010 also out then you should use
=IF(A1>40755,”out”,IF(A1<40391,”out”,”in”)), just to be on the safe side

It’s okay I’m on it…. can someone give me a formula that saves £3m in a rational and achievable way

Place all your costs in a column(in this case from a1 to a26, in b26 (or at the bottom of the column), enter the following and drag up

=IF(SUM($A$26:A26)>3000000,A26,””)

😆 @ CharlieMungus