With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
Friday, March 11, 2016
yogi_Compute Month By Month Date Of Event Held On Nth Weekday Of Month
return date for nth recurrence of a weekday in a month
I have events that recur on every nth day of the month. For example, every 3rd Tuesday. I need to populate a cell with the date next occurrence. Basically if today is 3/11/2016 and this particular event happens on every 3rd Tuesday of the month I need to return 3/15.
If today is 3/16/2016 I need to return the next yet to happen occurrence, so, 4/19.
Then I need to populate the next two occurrences, so, in the first example I'd have 3/15 then 4/19 and then 5/17.