finding days in Excel

[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

 

[icestationzbra]

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

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

 

[Bob Phillips]

or even

=TEXT(TODAY(),"dddd")

or

=TEXT(A1,"dddd")

 

[Arvi Laanemets]

Hi

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


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

or even

=TEXT(TODAY(),"dddd")

or

=TEXT(A1,"dddd")

 

[Dave Peterson]

I like this custom format:

mm/dd/yyyy* dddd

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