Find given day of supplied date's week in Excel -

Find given day of supplied date's week in Excel -

i have dates in column, , to, using dates in column i.e produce first column, based on in second

week starting date 01/11/2009 01/11/2009 01/11/2009 02/11/2009 01/11/2009 03/11/2009 01/11/2009 04/11/2009 01/11/2009 05/11/2009 01/11/2009 06/11/2009 01/11/2009 07/11/2009 08/11/2009 08/11/2009 08/11/2009 09/11/2009 08/11/2009 10/11/2009 08/11/2009 11/11/2009 08/11/2009 12/11/2009 08/11/2009 13/11/2009 08/11/2009 14/11/2009 15/11/2009 15/11/2009 15/11/2009 16/11/2009 15/11/2009 17/11/2009 15/11/2009 18/11/2009 15/11/2009 19/11/2009 15/11/2009 20/11/2009 15/11/2009 21/11/2009 22/11/2009 22/11/2009 22/11/2009 23/11/2009 22/11/2009 24/11/2009

is there formula this?

weekday returns index number day of week, can utilize next start of week:

=b1-(weekday(b1)-1)

excel