I have a spreadsheet that I inherited and am looking at updating info on it. A macro has been set to work out dates on a weekly basis based on number of sessions per week. What I am wanting to do now is change the code slightly so that the exact date fills in for each session rather than just the monday date. EG if a session runs on Monday and Thursday at present it only provides the date for the Monday but provides it twice whereas I now want it to provide the date for Thursday. I know excel works with adding day + 1 for each day but not sure how to convert to code to do that.



Hope someone can help.

Thanks in advance

Terri