Hi there
I have looked at some examples of Date formulas but still need help.
I would like a formula to work out the week of semester.
I have a list of dates in Column A and then in Column D I am trying to get a formula to look at the date in A and then calculate a week number of Semester. eg Week One, week Two etc.
I was thinking of having the Semester start date 04 March 2013 in a cell that is referenced by the formula. Not sure if a formula could also include a end date of Semester eg 28 June 2013
Any help would be appreciated
Bookmarks