Solved How to create days in a list of dates in exce

June 17, 2011 at 22:32:38
Specs: Windows 7
I have spreadsheet long list column of data with dates back to year 2005. I want to insert name of days beside the dates automatically. Doing it manually will takes a lot of time. Please help.

See More: How to create days in a list of dates in exce

Report •


#1
June 18, 2011 at 08:35:56
✔ Best Answer
If your data is in A1,
in B1 enter the formula: =DAY(A1)

Then Custom format cell B1,
Select Format,
Select Cells,
Select Number Tab,
Select Custom
In the Type box enter: ddd or dddd.
Three gives you the short day Sat
Four gives you the long day Saturday

You could also use the =TEXT() function to do the same thing.

With your data in cell A1
in cell B1 enter the formula: =TEXT(A1,"dddd")

as with the Custom Formatting,
Three d's gives you the short day Sat
Four d's gives you the long day Saturday

In both cases, drag the cell down as many rows as needed.

MIKE

http://www.skeptic.com/


Report •

#2
June 18, 2011 at 17:25:59
Thank you Mike for your clear answer and instruction, Problem solved. Thank you once again.
Ibrahim8900

Report •
Related Solutions


Ask Question