Posted by Michael Cunningham on July 16, 2001 2:38 PM
I am using excel 2000 for some data analysis. I need to break a list of 20,000 dates into workweeks (Intel workweeks). I could type in the entire calendar for the past 3 years and set each day equal to its corresponding work week number, but I still can't get an "IF" function to work (ie: if "cell x" = "cell y", return work week value in cell z, if not go to next row and run same function, keep repeating until you find a match for the day). Maybe there is an easier way to do this?