Date Formula

W

Woody13

Is there a way to have a forumla reference a date and then find the closest
Monday in the past? For example, if I had the date 11/19/2004 (which is a
Friday) is there anyway to have a formula "calculate" the date 11/15/04
which is the most recent Monday?
 
S

Sandy Mann

Ron,

I assume that you had a reason for suggesting that formula instead of
=E1-WEEKDAY(E1,3). If you did can I ask what it is?

Curious

Sandy
 
R

Ron de Bruin

Hi Sandy

Habit of always using the 2
Monday is for us the first day of the week
 
Top