finding days in Excel

A

Andy B.

Is there a format in Excel which returns the day for the date you put
in? or does it have to be done manually using lookup tables etc?

Thanks

Andy
 
I

icestationzbra

i hope you meant a worksheet function which would return the weekday fo
the date entered:

=TEXT(WEEKDAY(TODAY()),"dddd"
 
A

Arvi Laanemets

Hi

Or
=TODAY()
and format as Custom "dddd"


--
Arvi Laanemets
(When sending e-mail, use address arvil<At>tarkon.ee)



Bob Phillips said:
or even

=TEXT(TODAY(),"dddd")

or

=TEXT(A1,"dddd")
Click to expand...
 
D

Dave Peterson

I like this custom format:

mm/dd/yyyy* dddd

I can see the date and day of week in the same cell.
 
Top