Date Format [Closed]

Report
Posts
1
Registration date
Thursday November 13, 2014
Status
Member
Last seen
November 13, 2014
-
Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
-
Hi All,

I want use date 201201, how can this will be set in Execl Format.

please help me.

Thanks

1 reply

Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
791
2012 is year what is that 01 is it Jan or first date in the year
the date should have year month and date

for e.g. 20121101
is 1st november 201

in that case you type a f;ormula

=date(2012,11,01)
and enter
and see formula bar.

you can format the date anyway you like

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!