Returning the Beginning of the week

R

Rizitsu

Returning the beginning of the week.

e.g. if the date == 02/03/04 (Friday 2nd March 2004)

the beginning week for that date == 01/03/04 (Thursday 1st March 2004)

Hows does one go about achieving this?

Regards
 
C

crispbd

This formula will take a date in cell A1 and give the start of the wee
in B1

* assumes that monday is the start of the week, so if the date is
sunday in A1, it returns the prior monday

B1 = A1 - (Weekday(A1,vbMonday) - 1
 
Top