johnburgin
New Member
- Joined
- Feb 8, 2013
- Messages
- 33
Hi,
I am creating a 2-weekly calendar (Mon to Fri, week 1, Mon to Fri week 2). My spreadsheet contains booking dates for appointments, and uses a today formula in places. What I need to do on a separate sheet is have the dates of the current week as week 1, and the following week in week 2.
What kind of formula should I use to create the date so that Mon is the monday of the current week, tuesday is the tuesday of the current week etc. I am guessing for the following week I could simply add 7 days to the week 1 dates?
I hope this makes sense
I'm using Excel 2003.
Thanks
I am creating a 2-weekly calendar (Mon to Fri, week 1, Mon to Fri week 2). My spreadsheet contains booking dates for appointments, and uses a today formula in places. What I need to do on a separate sheet is have the dates of the current week as week 1, and the following week in week 2.
What kind of formula should I use to create the date so that Mon is the monday of the current week, tuesday is the tuesday of the current week etc. I am guessing for the following week I could simply add 7 days to the week 1 dates?
I hope this makes sense
I'm using Excel 2003.
Thanks