Webuser Forums: Day of week in Excel

You are not logged in.
Login | New user registration

Main Index | Search | Active Topics | Who's Online | FAQ / HELP

mgmcc
regular

Reg'd: Thu
Posts: 1104
Loc: Dundee, Scotland

Re: Day of week in Excel
Thu Jul 02 2009 08:20 AM

If you have the date in A1, make B1 =A1 and format it as Custom dddd

If you want the day and date in the same cell, format it as
dddd dd/mm/yyyy

--------------------
-
Mike

Post Extras

Jump to

Entire topic
Subject	Posted by	Posted on
Day of week in Excel	paymaster	Thu Jul 02 2009 07:28 AM
Re: Day of week in Excel	mgmcc	Thu Jul 02 2009 08:20 AM
Re: Day of week in Excel	The_Wanderer	Thu Aug 27 2009 01:09 PM

Extra information
0 registered and 1 anonymous users are browsing this forum. Moderator: Mouse, greysts, Hello_There, bricat, Joe_London, putasolutions, John_McKenna, TheFatControlleR Print Thread	Forum Permissions You cannot start new topics You cannot reply to topics HTML is disabled Mark-up is enabled	Rating: Thread views: 0

Main website

Navigation

Webuser.co.uk

Web User Alerts

Web User Network

Site Policies

Magazine Subscription

Contacts

Search