Sometimes my due dates need to be on the 15th of the month, for which DLL and Donkey gave me:
=DATE(YEAR(TODAY()), MONTH(TODAY()) + (DAY(TODAY()) > 15), 15)
This works great except sometimes the 15th is on a Sunday which means I need the result to be the 13th, and sometimes it's on a Saturday which means I need the result to be the 14th.
FYI: I am a n00b..
Bookmarks