Can you generate a date with limits?
I am working within a tracker, and I have the date autogenerating.
Currently the date will generate once the first update will occur, and I just did =[Review Date]@row + 60 so that it adds 60 days from the review date. However, the program ends 12/31 so I want to add a limit so that if 60 days from the review date is after 12/31, the date maxes out at 12/31. Is there a way I can do this?
Help Article Resources
Check out the Formula Handbook template!