+ Reply to Thread
Results 1 to 4 of 4

Want to have blank date cells yield weekday results AFTER I ENTER in a new date

  1. #1
    Registered User
    Join Date
    03-24-2024
    Location
    Vacaville, USA
    MS-Off Ver
    Office Home and Student 2019
    Posts
    1

    Want to have blank date cells yield weekday results AFTER I ENTER in a new date

    Hi- I'm pretty 'new' to excel Home & Student 2019. I have created a small table to track card game results and calculate winning percentages of different players. I was struggling with how to handle cells where I had not yet put in a new game date, and having 'blank' for the day-of-week appear if no date entered. I discovered the "IS BLANK" statement on Google, and Bob is my father's brother! I'm attaching my sheet for possible use by new players. I also have special formula language if a player has 'never' won a game, to eliminate error messages for divide by zero problems in winning percentage section. Hope this helps other 'newbies' (like me).
    '
    Attached Files Attached Files
    Last edited by FDibbins; 03-25-2024 at 12:06 AM. Reason: reinstated title

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,734

    Re: Want to have blank date cells yield weekday results AFTER I ENTER in a new date

    You can use this formula in B2:

    =IF(A2="","",TEXT(A2, "dddd"))

    then copy it down to B18.

    Hope this helps.

    Pete

  3. #3
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: I solved this myself - kindly delete

    Once a question has been asked and there are solutions posted, we do not delete it because it might be useful to others.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,939

    Re: Want to have blank date cells yield weekday results AFTER I ENTER in a new date

    I have replaced your title with what you had originally, please do not delete titles once they have been posted.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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: 3
    Last Post: 03-10-2019, 03:48 AM
  2. [SOLVED] If cell meets date requirement enter 1, if not enter 0, if blank don't enter anything.
    By billrogers184 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-11-2017, 02:04 PM
  3. Replies: 6
    Last Post: 11-02-2016, 09:54 AM
  4. Excel VBA code to return weekday name from a date then autofilters for userdefined weekday
    By studyengineering in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-10-2016, 03:24 PM
  5. [SOLVED] Calculate weekday end date based on sum of weekday start date and cell value
    By Rerock in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-01-2014, 09:17 AM
  6. [SOLVED] If formula, if two cells are blank, return blank, if one has a date, subtract todays date
    By amthyst826 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-06-2014, 12:47 PM
  7. [SOLVED] Auto calculate for date + days forward to yield new date
    By John Sullivan in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-22-2006, 12:25 PM

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