formating a cell with if and multiple date ranges

B

Brian Paff

I am trying to set up a cell that will look at another cell and
depending on the date in that cell, enter a number into this cell.
What I have so far is
=IF((E4>=DATE(2004,1,1))*(E4<=DATE(2004,12,31)),"04-","") Is there a
way to also have it say between 2005,1,1 and 2005,12,31 then 05-,""
and so on for 4 or 5 years?
 

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

Using CF to change colour in cell based on date? 4
Date Between IF And Statement 5
Referencing every nth cell in a new column 1
If statement with dates 0
Lookup a particular cell in another excel workbook 1
How To Have A Cell Be Blank If... 2
Conditional Formating with IF and AND formula 2
Conditioal formatting problem 3

Top