LinkBack URL
About LinkBacks
Hi, I need code of function weekday , when i key in the date start at b1. then it return value in yellow area at b2:h4.
how can i do it.
thank
Hi, I need code of function weekday , when i key in the date start at b1. then it return value in yellow area at b2:h4.
how can i do it.
thank
I think this is what you need
Then copy right
Please Login or Register to view this content.
ROW4, YOU CAN DO IT YOURSELF
I need your support to add reputations if my solution works.
I think B2 should beThen copy rightPlease Login or Register to view this content.
Looking for great solutions but hate waiting?
Seach this Forum through Google
www.Google.com (e.g. +multiple +IF site:excelforum.com/excel-general/ )
www.Google.com (e.g. +fill +combobox site:excelforum.com/excel-programming/ )
Ave,
Ricardo
You can get the short name for the day by using the Text function:
=TEXT($B$1,"ddd")
Alternatively if it is just a presentation issue, if you actually have the date you can just use a custom format of
ddd
Richard Schollar
Microsoft MVP - Excel
thank ,for your solution ,it work well
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks