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
Bookmarks