+ Reply to Thread
Results 1 to 4 of 4

if "Monday" is selected then following cells should show other weekdays

  1. #1
    Forum Contributor
    Join Date
    05-29-2017
    Location
    UK
    MS-Off Ver
    Pro Plus 2016
    Posts
    301

    if "Monday" is selected then following cells should show other weekdays

    Hello guys, to pick up your brain - as per Excel file attached, is there some simpler formula to:

    If C3=Tu (stands for Tuesday) then following cells should adjust accordingly - W, Th, F, Sa, Su, M, and so on…

    ...without writing some long formula...

    Thanking you!

    https://www.excelforum.com/attachmen...1&d=1506791726
    Attached Files Attached Files

  2. #2
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,357

    Re: if "Monday" is selected then following cells should show other weekdays

    maybe:
    row4 dates, format D
    row3 =row4, format DDD
    Attached Files Attached Files

  3. #3
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: if "Monday" is selected then following cells should show other weekdays

    Hi,
    D3 copied across

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  4. #4
    Forum Contributor
    Join Date
    05-29-2017
    Location
    UK
    MS-Off Ver
    Pro Plus 2016
    Posts
    301

    Re: if "Monday" is selected then following cells should show other weekdays

    Sorry Tim, maybe wasn't clear... but was looking exactly what Richard provided with. Thank you much, guys!! Appreciate your help. A ton.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 06-27-2017, 08:27 PM
  2. [SOLVED] Why does the "CountIF" function fails on value "Monday Week 1"?
    By kashbg in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 06-02-2015, 03:24 PM
  3. Replies: 3
    Last Post: 01-02-2014, 02:15 PM
  4. [SOLVED] How to USE """"" cells count """"" change font color
    By austin123456 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-09-2013, 06:14 AM
  5. Replies: 9
    Last Post: 11-06-2012, 08:59 AM
  6. Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",False)" not working
    By redders in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-31-2011, 03:52 PM
  7. if "a" selected from dropdown menu then show "K" in other cell
    By LEGALMATTERS in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-13-2006, 01:10 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1