How can I get the actual day in a cell?

July 20, 2011 at 03:08:51
Specs: Windows XP
How can I get the actual day in a cell in excel? Is there a function that gets the actual day from the pc?

See More: How can I get the actual day in a cell?

Report •

July 20, 2011 at 03:16:53
then on the format list (near the centre at the top) select "More Number Formats..." at the bottom of the list, choose "Custom" and type in "dddd" under where it says "type".

Report •

July 22, 2011 at 11:31:18
Were you looking for today's date? if so previous reply has it.

If you were looking for the number of the day of the date such as 15 for august 15th 1964, then you would use the DAY(A1) to get the number assuming that cell A1 contains the date in a valid date format.

if you were looking for the day of the week for june 3rd 2020, then you can use:

numbers 1 to 7 will be returned with 1 being sunday and 7 being saturday

combine this with a choose statement and you can get it to return The day of the week as a text value.


Just discovered this and much simpler


Report •
Related Solutions

Ask Question