day/date correlation

johnT · Sep 11, 2003

is there a way to have a date in one cell ie: 9/11/03 and
have the adjacent cell specify the correct day ie:
thursday???

Dan E · Sep 11, 2003

John,

If you had the date in A1 put
=TEXT(A1,"dddd")
into B1 (or wherever you like)

Dan E

Jason Morin · Sep 11, 2003

A1: 9/11/03
B1: =A1

Custom format B1 as dddd.

HTH
Jason
Atlanta, GA

Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell.	2	Dec 3, 2013
Calculate End Date Using Start Date and No. of Days excluding specific days.	0	Nov 22, 2013
Problem formatting dates from CSV file	2	Mar 9, 2014
Countif Function??	3	Mar 18, 2010
Calculating pay dates	4	May 28, 2010
Finding the date of the previous Thanksgiving Day	11	Sep 29, 2009
formatting excel date list	5	Jan 25, 2010
Formula to tell day of week	2	Apr 12, 2013

Ask a Question