Docketing with Outlook: calculating X number of days before a given date
Sponsored Links
In response to a question regarding my post on calculating dates in Outlook:
“This works great when using the + but mine doesn’t work when using -. Why???”
Excellent question! I was sure I had done this before, but when I tried it today, I couldn’t get it to work. So I did some digging and found out there is a way; you just have to type the word “before” instead of the minus sign.
Examples:
1week before
2days before
3months before
The formulas work whether they’re typed before or after the date, or even if you overwrite the date with them. Just tab out of the field, and the calculated date appears.
Sponsored Links
Leave a Comment