Thursday, November 20, 2014

yogi_List All Dates Of Specified Month of A Specified Year

               Google Spreadsheet   Post  #1840
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Nov-20-2014
post by ReiAyanami:
(https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!category-topic/docs/spreadsheets/cv5cnYHJ5Y4)
How to generate date ranges
Hi everyone

I have to generate a date interval per month and I'd like to do it in an automatic way
I'm going to esplain. 
Let's suppose we're on february I'd like to fill 28 rows of a given column with the dates 1 through 28
How could I do?
I can get the number of days of a month using datedif and a combination of year/month/today
That I'm not able to do is the filling part
Can anyone help me please

thx in advance

 ulix
--------------------------------------------------------------------------------------------


No comments:

Post a Comment