Results 1 to 4 of 4

Thread: Help with Date and Weekday Functions

  1. #1
    Neophyte pyrehn's Avatar
    Join Date
    May 2022
    Posts
    1
    Articles
    0
    Excel Version
    Excel 365 MSO

    Help with Date and Weekday Functions



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi there,
    I need help creating a formula that calculates the date in column A, cell 4 with month and numerical day (Jun 01), and then in the rest of the column as just the numerical day (ex. 2, 3, 4, 5). Then in column B I need it to calculate the matching day of the week Sun-Sat.

    So Row 1 would read - Jun-01 W
    Row 2 would read - 2 Th
    and so on.

    I'm currently using the TEXT function to calculate column A, and am using CHOOSE + WEEKDAY and a secondary sheet to calculate the day of the week.

    Is there any way to do this on a single sheet?
    I've attached a copy of my spreadsheet, any help is appreciated.

    Thank you so much
    Attached Files Attached Files

  2. #2
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,767
    Articles
    0
    Excel Version
    MS365 Sub (Insider) Win11
    What is wrong with the way you are doing it now? It is all on one sheet.
    Ali
    Enthusiastic self-taught user of MS Excel!

  3. #3
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,767
    Articles
    0
    Excel Version
    MS365 Sub (Insider) Win11
    In B4 drag copied down:

    =CHOOSE(WEEKDAY(B$1+ROWS($1:1)-1), "Su", "M", "T", "W", "Th", "F", "Sa")
    Attached Files Attached Files
    Ali
    Enthusiastic self-taught user of MS Excel!

  4. #4
    Neophyte Herbyb's Avatar
    Join Date
    Dec 2021
    Posts
    2
    Articles
    0
    Excel Version
    Excel 365
    Enter =TEXT(($B$1+ROW(A4)-4), "MMM-DD") in cell A4 and reference cell A4 in B4....by doing this "Sheet 2" is no longer required

Posting Permissions

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