get the month, day and year of australian time

**albert28** · 04-15-2014, 01:55 AM

Hi

i have an issue on getting the month, day and year if the dates is australian time.

example :

01/04/2014 i need to have month on column D which is April and Day is 1 and year is 2014 and whenever i reformat that dates into Text(a1,"mm/dd/yyyy") it is always looks the same. and if i change it directly to format into "mmm" in column D i have January not april.

please help.

thanks

**sktneer** · 04-15-2014, 02:36 AM

I think you should check you system date setting.

Go to Control Panel --> Regional and Language Options --> Customize --> Date --> Short Date Format. See here what format is set for your system date. It should be mm/dd/yyyy. Change it to dd/mm/yyyy. Hope that will solve your issue.

**albert28** · 04-19-2014, 04:57 AM

thanks sktneer!!

**sktneer** · 04-19-2014, 05:05 AM

Glad to help you.

You may also click on * (star) to Add Reputation, this is another way to say thanks to those who have put their time and efforts to help you in this forum.