Thread: excel & dates using If
View Single Post
Old 25-10-2007, 19:44   #4
TheNorm
Inactive
 
TheNorm's Avatar
 
Join Date: Jun 2006
Location: Cambridge
Services: Sky TV, VM TV, 20meg bb, tel, and a lobster (but the lobster died).
Posts: 4,349
TheNorm has a nice shiny star
TheNorm has a nice shiny starTheNorm has a nice shiny starTheNorm has a nice shiny starTheNorm has a nice shiny starTheNorm has a nice shiny starTheNorm has a nice shiny starTheNorm has a nice shiny starTheNorm has a nice shiny starTheNorm has a nice shiny starTheNorm has a nice shiny starTheNorm has a nice shiny starTheNorm has a nice shiny starTheNorm has a nice shiny starTheNorm has a nice shiny starTheNorm has a nice shiny starTheNorm has a nice shiny starTheNorm has a nice shiny star
Re: excel & dates using If
Quote:
Originally Posted by cimt View Post
I think that is mean to be in between the start date and todays date?
Oh! You want to combine two IF statements? How about this:

Code:
=IF($C$1>=A1,IF($C$1<=B1,"Week 1",""),"")
TheNorm is offline   Reply With Quote