Date Format

Closed
RMGP Posts 1 Registration date Thursday November 13, 2014 Status Member Last seen November 13, 2014 - Nov 13, 2014 at 02:43 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Nov 15, 2014 at 01:34 AM
Hi All,

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

please help me.

Thanks
Related:

1 response

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Nov 15, 2014 at 01:34 AM
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
0