First date

=A2-WEEKDAY(A2,2)+1

and then

=A2+1

etc.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"ascott" wrote in message
...
I need to create a biweekly time sheet from for all days including the
weekends and I need to know what formula you use to enter dates that will
automatically update themselves.