0

replicate week to start on tuesday

Joanne Chong

April 24, 2021 07:32

None

Follow

=@NL("columns=2","date",$F$10,$F$10,$C$8,"Period Type",$G$4)

This is the formula. It will always start on Monday. Any way to let it start on Tuesday?

The week date is tuesday to Monday?

• Facebook
• Twitter
• LinkedIn

1 comment

• 0
  
  Bryan Robinson May 17, 2021 13:22

  You could use that but in the cell below, add 1 to the result.  To get the end of the week, simply add 1 to your end date.  It also looks like you are using G4 to determine the type of period so you may need to build in logic to account for adding or not adding 1 to the period start and end. But you will need to enter the Monday for the start week otherwise your first start date will be the following week.  Will probably need to build logic for that aspect of the report as well.