Excel If Function over a range of dates

April 2018


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.
Published by aakai1056. Latest update on February 16, 2010 at 07:44 AM by aakai1056.
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 (https://ccm.net/).
Excel - Conditional Formatting using Dates
Excel - Comparing two columns A&B