Finding the end of 4 week

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I have given the task of preparing a time sheet with 4
weekly blocks. The very first block will start on the
first monday of a month and go on for 4 weeks with ending
on sunday. Then each further block will start with
mondays (after 4 weeks). My problem is finding the end of
4 week and then the monday. To add to the problem each 4
week must be on a seperate sheet and would go for a year.
Thanks for your help.
 
If your start date is in cell A1 of sheet1, then the ending date is

=A1+27

formatted for date.

For the next sheet, use for the start date

=Sheet1!A1+28
for the end date, the correct formula is still
=A1+27

and so on. For each sheet, simply reference the previous sheet.

HTH,
Bernie
MS Excel MVP
 
Back
Top