0
0
I need to calculate the first occurrence in the next year of the weekday of the date in cell A1. For instance, if the date in cell A1 happens to fall on a Thursday, calculate the first Thursday of the next year; if the date in cell A1 falls on a Monday, then calculate the first Monday of the next year, and so on.
How can I do this?
1First monday, in first week of january next year? Or first monday in the given week from the date in cell A1? – mk117 – 2014-03-25T08:08:15.337
@mk117 Seems pretty clear to me - the first occurrence of the given weekday next year, whichever week and month it falls to (though of course it'll be in the first or second week of January). – Indrek – 2014-03-25T09:13:37.357