A big dilema for me, I have class with students on monday and friday, i cannot figure out with excel how to return the day number of monday or friday on this month or next month eg. 19 sept is monday this week and next week is 26 september
I want to return next month that monday will be 3 then 10, 17
I tried a silly formula like =(19+7) return 26 but then show 33 but a month dont have 33 days.
Hope you guys understand me and maybe help me, thanks