Format Date

A

Alicia

Is there any way that when I enter a Date in say Cell A1, Cell A2 would be
able to reflect the Day?
 
F

Frank Kabel

Hi
try
=A1
and format with the custom format
DDDD

or use the formula
=TEXT(A1,"dddd")
 
A

Alicia

Thanks,
But currently i even have problem format date to watever format i want, like
dd-mmm-yy or dd/mm/yy... i know it is possible, there must be something in my
excel that is wrong. Any clue on wat might be wrong.
Even when i present calculation to auto, it will always still revert back to
manual, regardless of whether it is a new file created or existing file, is
there any reason on that. Whereas my colleague have the problem or always
revert to auto, even though he has set it to manual... its weird. Please
advise if you have any clue what when wrong.
 
F

Frank Kabel

Hui
for yopur formating issue: Are you sure your date values are really entered
as date values and not as 'Text' values?. Check this with
=ISNUMBER(A1)
This should return TRUE

For calculation settings: This is an application wide setting and determined
by the fIRST file you're opening
 
Top