|
|
#3
06-18-2017, 03:50 PM
|
|||
|
|||
Thank you so much for getting back to me NBVC,
I have 2 working the first date and the 12 month date. but the 6 month old date isn't working =AND(DATEDIF(A2,TODAY(),"m")>=6,DATEDIF(A2,TODAY() ,"m")<=12) the above formula doesn't do anything if the date is 6 months older than todays date.... Is there a way to make the colour stay in place for the full 6 months? So from today thru to 6months time it stays green. Then from 6month to 12 months its orange and then 12months old it stays red? What am I doing wrong haha 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Microsoft Project 2016 print specific date range stuck on one date | martinsalmon | Project | 1 | 10-12-2016 11:36 AM |
 Date picker content control to always show current date.
|
lucky16 | Word VBA | 2 | 07-01-2016 01:14 PM |
| Project 2013 - Change GANTT Bar Colour By Main Task Date | CaelanT | Project | 1 | 02-09-2015 12:50 PM |
|
How can a document have the same date modified/create date, yes have have actual file content?
|
legaleagle | Word | 15 | 01-07-2015 06:58 PM |
| Excel pivot table with a DATE value field for some reason stops at a certain date | angie450 | Excel Programming | 2 | 08-19-2014 08:50 AM |
Windows XP 
Office 2013
Threaded Mode