yogi_List In Cells A9:A Pay Period Dates Starting From Date In Cell B6 To End Of Month Of Date In B6

Google Spreadsheet   Post  #2488

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Aug-16-2018

question by: Mobility Project PT
https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/MndAN1XVBlQ;context-place=mydiscussions
Autofill dates for bi-monthly timesheet?
I have a timesheet to record worked hours. We have two pay periods that run from the 1st to 15th day of each month, and then from the 16th to the last day of the month. I have found a formula to autofill dates but can't figure out how to make it stop on the 15th (if starting on the 1st) or stop on the last day of the month (if starting on the 16th)

=ArrayFormula(ADD(A1,row(INDIRECT("A1:A"&16))))

What would you do? Thanks!