Can anyone help please? I am trying to add a division's column, which are taken from a date range in another column. I.e. I would like to add "Scb", years 1994-1995, "J" 1996-1997, "Y" 1998-1999 and "E" over 1999. Is there anyway I can do this? Any help would be appreciated. Thank you
Suppose your values are in Cell A2 then put this formula in Cell B2 and drag it down
Thanks to mubashir aziz
for this tip on the forum.
This document, titled « Excel If Function over a range of dates », is available under the Creative Commons
license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM