Monday, October 31, 2016

yogi_Create Formula For Consecutive Dates Repeated Specified Number Of Times Leaving Specified Number Of Cells Blank

Google Spreadsheet   Post  #2080
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Oct-31-2016
question by: Whitney Lewis:
https://productforums.google.com/forum/#!topic/docs/MIKhgFpAau4;context-place=forum/docs
How to create formulas for consecutive dates in cells?
Hi I have column "B" with date of 10/29/16 entered in cells 510 through 531.

I would like the next set of cells in column "B" 534 through 555 to read next date of 10/30/16

and then continue through the sheet.


Is this formula possible?
------------------------------------------------------------------------------------------------------------------