Returning Day from Date

mpantalo

New Member
Joined
Nov 3, 2005
Messages
27
I have a column with a range of dates and I need to insert another column to return the day of the week. The date format of the cells are 25/12/2006 etc.
 

Some videos you may like

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

Watch MrExcel Video

Forum statistics

Threads
1,114,675
Messages
5,549,367
Members
410,911
Latest member
AniEx
Top