Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-30-2023, 07:18 AM
Kwmck328 Kwmck328 is offline Project a number (120) into future cell from a specific date Mac OS X Project a number (120) into future cell from a specific date Office for Mac 2011
Novice
Project a number (120) into future cell from a specific date
 
Join Date: Feb 2015
Posts: 23
Kwmck328 is on a distinguished road
Smile 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.
Reply With Quote
  #2  
Old 03-31-2023, 01:01 PM
kilroyscarnival kilroyscarnival is offline Project a number (120) into future cell from a specific date Windows 10 Project a number (120) into future cell from a specific date Office 2021
Expert
 
Join Date: May 2019
Posts: 344
kilroyscarnival is just really nicekilroyscarnival is just really nicekilroyscarnival is just really nicekilroyscarnival is just really nice
Default

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.
Attached Images
File Type: jpg date cond format.jpg (128.1 KB, 6 views)
Reply With Quote
Reply

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
Project a number (120) into future cell from a specific date Date field - future date calculation + only business days neon4 Word 7 01-21-2016 02:21 PM
Project a number (120) into future cell from a specific date entering future dates for a project that has started ketanco Project 5 12-15-2011 07:16 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:04 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft