Calculating cell entry from a date range
Posted by Dave Harrison on February 15, 2002 4:27 AM
Hello, I need to split the year up into "weeks" i.e. "week 1" to "week 52". Based on an inputted date, I need to assign a "week number".
I have a table set up, each row giving the week, the start and end dates i.e.
Week 1 01/04/2001 07/04/2001
Week 2 etc etc
At the moment I use nested IF statements in 10 seperate columns (due to max limit of 7 nested statements) to work out whether an inputted date is within each "week".
This all works fine, but the file size is huge, is there another way in excel 2000, an equivalent of a data lookup table say.
All the best,