Hi guys,
So I have a timetable which my team completes monthly. Some of the tasks only have to be completed quarterly, so I want the Status column (column E) to automatically say 'Not Required' on all months which are NOT our quarterly months.
So the months they would not be required are February, March, May, June, August, September, November and December. The current month is populated in cell A1.
So I guess I'm looking to include a formula somewhere, ideally not in Column E, which says if A1="February" then E5="Not Required","")
(I should point out I've successfully used a nested IF formula actually in the Status cell, but I really want the formula somewhere it won't be touched, which points to a range or something as the status column is really for people to type in so the formula might get messed up)
Any ideas?
Jem :-)
Bookmarks