CODEWITHSUNDEEP
excelexcel-formula
D C
D C

Reputation: 20

Incrementing day in date every 6 cells starting at a cell that's not 1

I am having trouble incrementing my days correctly. I need them to increment every 6 cells (which is working) but it is starting the increment from cell 1, and i need it to start at cell 4.

here is my function

=DATE(YEAR($B$4),MONTH($B$4),DAY($B$4)+INT((ROW()/6)))

and here is an image of my spreadsheet

spreadsheet

Upvotes: 0

Views: 164

Answers (1)

Gary's Student
Gary's Student

Reputation: 96773

Try:

=DATE(YEAR($B$4),MONTH($B$4),DAY($B$4)+INT((ROWS($1:1)/6)))

put anywhere and copy downward.

Upvotes: 2

Related Questions