I am looking to resolve an issue with date periods (not the normal is it a Monday etc). I have a spreadsheet that contains Dates in Column I, in column A I want to add some text if the date falls within a period to say "AP 1" or "AP 2" etc. My date periods are not normal Month Begin and End...