#1
|
|||
|
|||
Project a number (120) into future cell from a specific date
Cell L5 has Date (16 dec 2022), and I need to project a warning cell N19 that indicates L5 plus 120 days, with result in cell N19 showing "120" and cell fill colour or flag "yellow". This repeats every 120 days from L5. |
#2
|
|||
|
|||
Hi, I'm not sure why those cells are so far apart. If your cell L5 is formatted as a date in whatever format (i.e., not just text), you can simply have another cell do the calculation:
=(L5+120) to yield the date that is 120 days after the date in L5. If you want the cell to go yellow when that 120 days has passed, you'll want to apply conditional formatting. If your target cell contains the date 120 days after your original date, it'll look something like the example pic I'm adding. Basically I'm asking if today's date is greater than or equal to the target date, and if so, applying the yellow fill color. If you really only want "120" in the target cell, then your conditional formula would be like =TODAY()>= ($L$5 +120). Hope I got what you are asking, and that that makes sense. If you have rows of these, presumably like invoices with dates in one column, you can run the =l5+120 formula down the page, and the conditional formatting can be applied to the whole column; just omit the $ in the cell locations. |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Estimate date based on number of resources allocated to project | snakespan | Project | 0 | 10-09-2021 06:59 AM |
Microsoft Project 2016 print specific date range stuck on one date | martinsalmon | Project | 1 | 10-12-2016 11:36 AM |
Calculate number of days in a table from a specific date | tstolbert | Word | 2 | 06-25-2016 02:30 PM |
Date field - future date calculation + only business days | neon4 | Word | 7 | 01-21-2016 02:21 PM |
entering future dates for a project that has started | ketanco | Project | 5 | 12-15-2011 07:16 PM |