Date/Day

  • Thread starter Thread starter Omer
  • Start date Start date
O

Omer

Hi,

How do I make Excell tell me the day that the Date
corresponds to.

Example: If I have 8/7/03 in a column, I want to be able
to enter a formula in the next column such that Excell
would tell me it is Thursday

Thx
Omer
 
Omer,

Look at the WEEKDAY function.

From Help

Syntax

WEEKDAY(serial_number,return_type)

Serial_number is a sequential number that represents the date of the day
you are trying to find. Dates may be entered as text strings within
quotation marks (for example, "1/30/1998" or "1998/01/30"), as serial
numbers (for example, 35825, which represents January 30, 1998, if you're
using the 1900 date system), or as results of other formulas or functions
(for example, DATEVALUE("1/30/1998")). For more information about how
Microsoft Excel uses serial numbers for dates, see the Remarks section.

Return_type is a number that determines the type of return value.

Return_type Number returned
1 or omitted Numbers 1 (Sunday) through 7 (Saturday). Behaves like previous
versions of Microsoft Excel.
2 Numbers 1 (Monday) through 7 (Sunday).
3 Numbers 0 (Monday) through 6 (Sunday).

PC
 
With the date in A1
=CHOOSE(WEEKDAY(A1,1),"Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday")

Dan E
 
Here is yet another way to do it: assume 8/7/03 is in cell B3. In cell D3,
enter the formula =B3 and spread it down the column for all the dates
listed. Then change the format of the column. Format-Cells-Number-Custom; in
the "Type" box enter dddd.
 
Or -yet another option:
Format the very same column -the original date column- custom format "dddd m/d/yy".
 
Back
Top