Forum Discussion
Formatting combined data
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
Assume you want to generate all dates in 2024, so 365 dates, in 1 row:
=DATE(2024,1,SEQUENCE(,365))in 1 column:
=DATE(2024,1,SEQUENCE(365))then select the generated cells and apply them the Custom Date Format discussed above
See the attached workbook for examples and explanatory information (see especially the _Info worksheet) and alternatives.
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.
- 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! See the attached demo workbook. There is a WORKDAY formula in B1, and this has been copied to the right.
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/2024 Wednesday-01/03/2024 Thursday-01/04/2024 Friday-01/05/2024 Monday-01/08/2024 Creating a sample workbook reflecting your setup shouldn't take more than 5 minutes
Up to you though...
- No sorry. Thank you anyway.
- 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? - 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
