Thread: Project a number (120) into future cell from a specific date
View Single Post
 
Old 03-30-2023, 07:18 AM
Kwmck328 Kwmck328 is offline Mac OS X Office for Mac 2011
Novice
  
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