Date formatting to display e.g. January 15 2018

[Kelli*]

Hello,

I'm probably over thinking this, but if anyone can throw some light on this it would be greatly appreciated.

kind regards,

Kelli Webb

 

[NARAYANK991]

Hi ,

What happens when you use a cell format of :

mmmm dd yyyy

Narayan

 

[Kelli*]

Hi ,

What happens when you use a cell format of :

mmmm dd yyyy

Narayan

Pefect as always, I thought I tried that

 

[Hui]

For 15 Jan 2018

m is 1 for January
mm is 01 for January
mmm is Jan
mmmm is January

d is 15
dd is 15
if the day was 9th
d is 9
dd is 09

y or yy is 18
yyy is 2018
yyyy is 2018

 

[Kelli*]

For 15 Jan 2018

m is 1 for January
mm is 01 for January
mmm is Jan
mmmm is January

d is 15
dd is 15
if the day was 9th
d is 9
dd is 09

y or yy is 18
yyy is 2018
yyyy is 2018

Love your work! thanks I will keep this.