#1
|
|||
|
|||
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! |
#2
|
|||
|
|||
Maybe like the attached.
|
#3
|
|||
|
|||
Thanks - looking forward to trying this once I get to work!
|
Tags |
conditional formatting, dates, range |
|
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 |