Forum Discussion

Birdiedahlby11's avatar
Birdiedahlby11
Copper Contributor
Dec 28, 2023
Solved

Formatting combined data

Is it possible to format a spreadsheet with multiple data in the cells? I need to create a yearly spreadsheet with the dates written as (example): Monday-02/06/2024. Due to the nature of the spreadsh...
Formulas and Functions
  • HansVogelaar's avatar
    HansVogelaar
    Dec 28, 2023

    Birdiedahlby11 Select the cells with the dates.

    Select 'More Number Formats...' from the 'Number Format' dropdown on the Home tab of the ribbon.

    Select Custom in the Category list.

    Enter the following in the Type box, then click OK.

     

    dddd-mm/dd/yyyy

     

    or if you use European d/m/y format:

     

    dddd-dd/mm/yyyy

Birdiedahlby11's avatar
Birdiedahlby11
Copper Contributor
Dec 28, 2023
Thank you. I tried that but it didn't work. Here is what I am trying to achieve on a spreadsheet. I am thinking it's not possible because I have the days of the week attached to the month/day/year. I am using a spreadsheet that was created by another department and this is how they want it. I have to add dates for the new year; its an educational setting and the worksheet is used to track attendance.

Thursday-02/29/2024 Friday-03/01/2024 Monday-03/04/2024
Lorenzo's avatar
Lorenzo
Silver Contributor
Dec 28, 2023
Sorry but I don't understand why this doesn't work and what 'I have the days of the week attached to the month/day/year' actually means
Could you please post your workbook, or if not yet allowed here upload & share it with OneDrive, Google Drive or any other file sharing service?
  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Dec 29, 2023

    Birdiedahlby11 

    Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar? Alternatively, you can attach it to a private message to me. Thanks in advance.

  • Birdiedahlby11's avatar
    Birdiedahlby11
    Copper Contributor
    Dec 29, 2023
    When I put the formula you showed me in my worksheet I get an error message. (see below).
    I have data in the first five columns of the worksheet so put my first date in column F, then typed the formula you showed in your worksheet in column G.

    Tuesday/01/02/2024 #VALUE!
  • Birdiedahlby11's avatar
    Birdiedahlby11
    Copper Contributor
    Dec 29, 2023

    Lorenzo 

    This is what I am trying to do across the top of worksheet. I had to type these individually because I can't get the series function to work.

    Tuesday-01/02/2024Wednesday-01/03/2024Thursday-01/04/2024Friday-01/05/2024Monday-01/08/2024
         
         
         
         
         
         
         
         
         
         
         
         
         
         
  • Lorenzo's avatar
    Lorenzo
    Silver Contributor
    Dec 28, 2023

    Birdiedahlby11 

     

    Creating a sample workbook reflecting your setup shouldn't take more than 5 minutes

    Up to you though...

  • Birdiedahlby11's avatar
    Birdiedahlby11
    Copper Contributor
    Dec 28, 2023
    No sorry. Thank you anyway.

Resources