Has anyone been able to enter a date and then have the system calculate a date 7 days out, 14 days out and 28 days out automatically in separate fields. system
welcome to the community
I could not find exactly what you were looking for, but something similar. Use workday:
Replace DATEFIELD with your date attribute you want to use.
This will calculate a date after usually 14 days (which are usually 10 workdays)
WORKDAY(start_date, num_days, [holidays])
Explanation: Calculates the end date after a specified number of working days.
Maybe you can also build something complex using DATE:
DATE(year, month, day)
Explanation: Converts a year, month, and day into a date.
Thank you Micck.
That worked to perfection!
Too bad we can’t take it a step further at this point and conditionally format when the date exceeds the set parameters … I’m sure it’s coming soon.