I want excel to give me the day of the week (monday, tuesday,...) when the day of the current month is typed - e.g today is 11th of July a satuday, so when the user types just 11 in C5, I want D6 to display Saturday. Excel should always show the nth day of the week for the current month.
Note: I don't want column C to be date formated, it just contains whole numbers, 1 to 31). D6 should show Mon-Sun
thanks
Last edited by John19; 07-11-2015 at 06:32 PM.
can they type the full date in c5
if so then format the cell to
custom>
DDDD
and it will show
Saturday
otherwise you will need some VBA
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
One way:
Row\Col C6: =TODAY()-DAY(TODAY())+C5 Format of C6: dddd
Entia non sunt multiplicanda sine necessitate
that's it - done works perfectOriginally Posted by shg
thank you
Ok, in your original post before your edit - you wanted the result the same cell as the 11 was typed into - hence my response
glad you have a result now you have clarified it can be on a different cell
This will give you the Name of the weekday if today() is entered in A2 and the number of the date is in B2.
Formula:
Please Login or Register to view this content.
Darn: read it wrong again
Last edited by newdoverman; 07-11-2015 at 06:56 PM.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
sorry my mistake
no problem, just clarifying why i suggested VBA ,as the post looks strange from a google search
Here's another one that returns a TEXT value.
Assumes the number will always be a valid day of the month. For example, the number for February will never be 30 or 31.
=TEXT(C5&TEXT(NOW(),"mmm"),"dddd")
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Or
=DATE(YEAR(TODAY()),MONTH(TODAY()),C5)
Format of C6: dddd
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks