Formula for looking at 1 cell with a date and then comparing it to four date ranges

		Microsoft Office Forums > Microsoft Excel > Excel
Formula for looking at 1 cell with a date and then comparing it to four date ranges

FAQ

Thread Tools

Display Modes

10-27-2017, 07:25 AM

LearningMom LearningMom is offline

Windows Vista Formula for looking at 1 cell with a date and then comparing it to four date ranges

Office 2007

Novice

Join Date: Feb 2015

Posts: 8

Formula for looking at 1 cell with a date and then comparing it to four date ranges

We have one column with a last date gave. We want to write a formula that looks at that cell and outputs a "0" if it is before 06/30/2014 outputs a "1" if the date in the cell is between 7/1/2014 and 6/30/2015 and then a "2" if it is between 7/1/15 and 6/30/16 and a "3" between 7/1/16 and 6/30/18

Thank you

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Index match two date ranges	toddkad	Excel	9	11-03-2016 03:10 AM
Counting How many Times a date appears between two ranges of dates	Mars	Excel	1	10-21-2016 02:21 PM
calculate date if date entered in cell, do nothing if blank	ConfuddledOne	Excel	3	11-07-2014 09:37 AM
Inconsistent Duration column for the same date ranges	ravl13	Project	3	07-28-2014 05:16 PM
Make table cell active add date count date	MelHerndon	Word VBA	3	01-21-2013 04:23 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:59 AM.