Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 12-07-2018, 06:18 PM
onmytenthlife onmytenthlife is offline Mac OS X Office 2010 32bit
Novice
 
Join Date: Jun 2018
Posts: 4
onmytenthlife is on a distinguished road
Default Specific Formula Please varied date ranges

Hello, Guru's - thank you for being so amazing. Searched everywhere for this conditional formatting formula on youtube - I can't seem to nail it down. Heres the deal.




I have a column of varied dates.

I want to know
If greater than 365 days from cell date but less than 547 days (one color)
then in that same column
If greater than 547 days but less than 730 days (another color)

Basically, I have a column of peoples names who have started a program, and then in the next column, I have a list of the dates they started the program. There are milestones when they've been around for a year and then another one when they've been around for 18 months. I might even like to add one for if they've been around for over two years. I would then like to re-order the list in chronological order, but there are many other columns involved with insurance, SS# etc which makes me nervous. Thanks!
Reply With Quote
  #2  
Old 12-08-2018, 12:59 AM
xor xor is offline Windows 10 Office 2016
Expert
 
Join Date: Oct 2015
Posts: 909
xor is a jewel in the roughxor is a jewel in the roughxor is a jewel in the roughxor is a jewel in the rough
Default

Maybe like the attached.
Attached Files
File Type: xlsx GT365.xlsx (11.3 KB, 3 views)
Reply With Quote
  #3  
Old 12-09-2018, 07:09 AM
onmytenthlife onmytenthlife is offline Mac OS X Office 2010 32bit
Novice
 
Join Date: Jun 2018
Posts: 4
onmytenthlife is on a distinguished road
Default

Thanks - looking forward to trying this once I get to work!
Reply With Quote
Reply

Tags
conditional formatting, dates, range

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula for looking at 1 cell with a date and then comparing it to four date ranges LearningMom Excel 3 10-27-2017 12:44 PM
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
Inconsistent Duration column for the same date ranges ravl13 Project 3 07-28-2014 05:16 PM
Date specific formula Query Mukiwi Excel 4 03-20-2014 06:33 AM


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


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft