Saturday, February 11, 2012

yogi_Create Column Headings Involving Weekly Mix of Dates And Months

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                            www.energyefficientbuild.com

user farhaan100 said:
Date Ranges
I want the heading with fixed intervals for a period of 6 months..
8-14 Feb 15-22 Feb and so on...
If I am using the AND Function, it is adding the 2 dates and giving the output in nos and not the data as I want... and also since I want the date ranges for 6 months, it is too mechanical to type these manually..
Can any one help me out.. ?
-------------------------------------
following is a solution to the problem