chronological date selection
 

Hello,
I have a list of student names in column A1 and their birth date in B1. I have to calculate the closest wednesday and friday to their birth date to be able schedule birthday parties on those dates. However, I need to be able to figure out a way so that I calculate one student's party date (which would be on a Wed) and the next student's date (the next Friday) and so on down the list. I need to schedule parties on wed and Fri each week according to their birthday date.

This was way too hard for me to do and non of the other teachers have been able to find a way to do this either. Can someone please help?

thank you very much

chronological date selection
 

hi,

wednesday
=B2+MOD(8+(3-WEEKDAY(B2)),7)

friday
=B2+MOD(8+(5-WEEKDAY(B2)),7)

isabelle

Le 2015-04-17 12:46, lakke2120 a écrit :
Hello,
I have a list of student names in column A1 and their birth date in B1.
I have to calculate the closest wednesday and friday to their birth date
to be able schedule birthday parties on those dates. However, I need to
be able to figure out a way so that I calculate one student's party date
(which would be on a Wed) and the next student's date (the next Friday)
and so on down the list. I need to schedule parties on wed and Fri each
week according to their birthday date.

This was way too hard for me to do and non of the other teachers have
been able to find a way to do this either. Can someone please help?

thank you very much