Need a macro to count certain days Sun, Tues, Thurs for a gym membership sheet

I need a macro to count only certain days of the week. Sunday, Tuesday and Thursday. I have a gym class which lasts 12 consecutive sessions that are on Sunday, Tuesday and Thursday.

So if they join on day xx/xx/xxxx I would like the macro to calculate when the due date is.

Hard or easy?

Hi and welcome to the board

What do you mean by due date? The Next session date?Does it have to be VBA ?

Hi, thanks for the welcome and for replying.

I didn't explain very well. How it works is the member joins say on a Sunday. The membership entitles them to 12 consecutive sessions. The sessions only take place on a Sunday, Tuesday, Thursday. So after 4 weeks of Sunday, Tuesday, Thursday their membership is over and they are due to repay.

I can't just do 4 weeks because if they join on a Thursday as opposed to a Sunday the result is wrong. As i write it to you i'm thinking it might be possible to come up with a date formula somehow.

Originally Posted by arthurbr

Hi and welcome to the board

What do you mean by due date? The Next session date?Does it have to be VBA ?

any help on this?