Calculate date

G

Gary

I am looking for an easy way to calculate

A1= any date, B1=Monday of that week. For example,
A1=7/8/04, how can I have B1 = 7/5/04?
 
N

Norman Harker

Hi Gary!

One way:

=A1-WEEKDAY(A1,3)

It returns the same date if that date is a Monday.

I'm assuming that you regard your week as starting on a Monday rather
than on Sunday. Thus the Monday of the Week that Sunday 11-Jul-2004
falls in is regarded as 5-Jul-2004 and not 12-Jul-2004.
 
Top