Format Date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there any way that when I enter a Date in say Cell A1, Cell A2 would be
able to reflect the Day?
 
Hi
try
=A1
and format with the custom format
DDDD

or use the formula
=TEXT(A1,"dddd")
 
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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Format where ANY date is >= 30, 60, 90 days EXCEL 2007 1
Populate row with work days 1
conditional format cells by date 2
Excel Spreading dates evenly in a row of cells 2
Help to create a macro 2
formula in conditional formatting with dates 3
conditional formatting 6
date 2

Back
Top