jmking1999
New Member
- Joined
- Apr 29, 2022
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
Hello.
I am trying to have a cell display a "Due No Later Than" date.
I would like to use Lookup in a row and take the last posted date of occurrence used and add 14, 21, 90, etc... days to last occurrence displayed.
I also need to compare that result to end of month or end of the quarter date and display the earlier of the two dates.
Example would be a task must be completed at least ever 6 weeks, and also at least twice a quarter. Or another example would be once a quarter but no more than 90 days apart.
I am trying to have a cell display a "Due No Later Than" date.
I would like to use Lookup in a row and take the last posted date of occurrence used and add 14, 21, 90, etc... days to last occurrence displayed.
I also need to compare that result to end of month or end of the quarter date and display the earlier of the two dates.
Example would be a task must be completed at least ever 6 weeks, and also at least twice a quarter. Or another example would be once a quarter but no more than 90 days apart.