Excel If Function over a range of dates

November 2016


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.

Related :

This document entitled « Excel If Function over a range of dates » from CCM (ccm.net) is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the license, as this note appears clearly.