Calander

[#1]

Hi,

How to convert [Mar 2014] as  3/30/2014 and create calander based up on this

out put then calander

Mar 2014---3/30/2014

Apr 2014----4/31/2014

till december  12/31/2014

[Anonymous]

Hi,

Like this maybe.

TEST:

LOAD F1,

     Date(MonthEnd([41699]),'M/DD/YYYY') as Date1,

     Sales,

     value

FROM

[..\..\..\..\Downloads\calander.xlsx]

(ooxml, embedded labels, table is Sheet1);

Regards.

[sunny_talwar]

I agree with Jannet Santos‌. You should be able to use MonthEnd function to get to the dates you are looking for.

[#4]

I am agree too. Regards!