Time update

[brettexcel]

I am trying to make a new timecard at work and would like to make the time automatically update in the B column. The trick is that I would like it to update for the week and reset itself on each monday. That way people here at work just have to open the file and dont have to worry about typing it in. My job is all about conserving time. I have already set autocalc for the shifts hours and things like that but the date is the last hurdle. Can anyone please help me?

[duane]

this will result in a Monday date at all times

=TODAY()-WEEKDAY(TODAY(),3)