Friday, March 11, 2016

yogi_Compute Month By Month Date Of Event Held On Nth Weekday Of Month

Google Spreadsheet   Post  #2052
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Mar-11-2016
post by: Jennifer Eaton:
https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/9PGpaV9EzXA;context-place=forum/docs

return date for nth recurrence of a weekday in a month


Hello
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.


Any help would be greatly appreciated.
---------------------------------------------------------------------------------------------------

No comments:

Post a Comment