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, 12:09 PM

NBVC

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

Office 2013

The Formula Guy

Join Date: Mar 2012

Location: Mississauga, CANADA

Posts: 215

Maybe?

Code:

=IF(M4955<=DATE(2014,6,30),0,IF(AND(M4955>=DATE(2014,7,1),M4955<=DATE(2015,6,30)),1,IF(AND(M4955>=DATE(2015,7,1),M4955<=DATE(2016,6,30)),2,IF(AND(M4955>=DATE(2016,7,1),M4955<=DATE(2018,6,30)),3,""))))

« 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 09:37 AM.