Date Format

[Closed]
Report
Posts
1
Registration date
Thursday November 13, 2014
Status
Member
Last seen
November 13, 2014
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
Hi All,

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

please help me.

Thanks

1 reply

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
801
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