Solved get 'day' in cell C1when enter dd/mm/yyyy in cell 'B1'

Acer Acer revo rl100-ur20p desktop compu...
August 4, 2012 at 09:39:25
Specs: Windows 7, pentium4 2GHz / 2gigs
cell B1 enter 04/08/2012, how to get SATUR DAY In cell C1

See More: get day in cell C1when enter dd/mm/yyyy in cell B1

Report •


#1
August 4, 2012 at 11:47:16
✔ Best Answer
Simplest way:

In cell C1 enter the formula: =B1
then simply format the cell to show the day of the week: Format,Cells,Number,Custom and using the code ddd or dddd.

MIKE

http://www.skeptic.com/


Report •
Related Solutions


Ask Question