Using IF formula with ISBLANK

[banker123]

First time poster. I am trying to accomplish two things:

1 - I want to use an IF formula to determine if the contents of the cell (A1) is less than the year 2012

2- If the cell is blank, I want it to return "blank"

Is it possible to craft this into one formula? I don't work with excel a ton but I'm the most experienced in my department. Thanks in advance for any help received.

[Melvinrobb]

In the formula below, replace "True" with what you want returned if the date in cell A1 is before January 1, 2012, and replace "False" with what you want returned if it is not.

Please Login or Register  to view this content.

[banker123]

Worked like a charm, thanks so much.

[banker123]

I've hit a snag, one of the columns is formatted as a date for personal financial statements such as 1/1/2012. We require all financial statements to be within a year so I need to tweak the formula above to:

1-determine if the contents (1/1/2012) is more than a year old (using today's date).

2-if the cell is blank, I want it to return "blank".

[Melvinrobb]

This should work:

Please Login or Register  to view this content.