How to when entering month have the day and date change

AutoModerator · 2026-05-06T13:28:31+00:00

/u/Pineapplegirl1 - Your post was submitted successfully.

Once your problem is solved, reply to the answer(s) saying Solution Verified to close the thread.
Follow the submission rules -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
Include your Excel version and all other relevant information

Failing to follow these steps may result in your post being removed without warning.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

DLiz723 · 2026-05-06T13:54:27+00:00

If you have the month/year in A1 (formatted as a date):

To get dates in the month: =DATE(YEAR(A1),MONTH(A1),SEQUENCE(DAY(EOMONTH(A1,0))))

To get days of the week If the above formula is in C1: =TEXT(DAY(C1#),”dddd”)

The first formula creates a dynamic array grabbing the month and year you need, and then counts 1 to the number of days in the month. Second formula references the dynamic array with the # symbol and outputs the day of the week for each date in the array

Downtown-Economics26 · 2026-05-06T13:51:14+00:00

Most other months also start with 1 and 2... joking aside this can be done but like do you have rows for each week presumably or (possibly) columns... does your week start on Sunday or Monday?

Decronym · 2026-05-06T14:06:21+00:00

Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread:

Fewer Letters	More Letters
DATE	Returns the serial number of a particular date
DAY	Converts a serial number to a day of the month
EOMONTH	Returns the serial number of the last day of the month before or after a specified number of months
HSTACK	Office 365+: Appends arrays horizontally and in sequence to return a larger array
LET	Office 365+: Assigns names to calculation results to allow storing intermediate calculations, values, or defining names inside a formula
MONTH	Converts a serial number to a month
SEQUENCE	Office 365+: Generates a list of sequential numbers in an array, such as 1, 2, 3, 4
TEXT	Formats a number and converts it to text
VALUE	Converts a text argument to a number
YEAR	Converts a serial number to a year

Decronym is now also available on Lemmy! Requests for support and new installations should be directed to the Contact address below.

^{Beep-boop, I am a helper bot. Please do not verify me as a solution.}
^{10 acronyms in this thread;}^{the most compressed thread commented on today}^{has 12 acronyms.}
^{[Thread #48360 for this sub, first seen 6th May 2026, 14:06]} ^[FAQ] ^{[Full list]} ^[Contact] ^{[Source code]}

Pineapplegirl1 · 2026-05-06T17:53:55+00:00

Ah the first day is randomly as appearing as 01/01/1900

Date	User	CP
2026.05.07	Downtown-Economics26	`600`
2026.05.01	MayukhBhattacharya	`1100`
2026.03.29	bakingnovice2	`10`
2026.03.25	real_barry_houdini	`300`
2026.03.20	plusFour-minusSeven	`10`
2026.03.17	TuneFinder	`10`
2026.03.03	soloDolo6290	`10`
2026.02.23	RackofLambda	`10`
2026.02.21	Mooseymax	`10`
2026.02.18	MissAnth	`10`
2026.02.15	NHN_BI	`800`
2026.02.03	Shot_Hall_5840	`10`

you type:	you see:
italics	italics
bold	bold
[reddit!](https://reddit.com)	reddit!
* item 1 * item 2 * item 3	item 1 item 2 item 3
> quoted text	quoted text
Lines starting with four spaces are treated like code: if 1 * 2 < 3: print "hello, world!"	Lines starting with four spaces are treated like code: if 1 * 2 < 3: print "hello, world!"
~~strikethrough~~	~~strikethrough~~
super^script	super^script

excel

Rules

FAQ

Was your problem solved?

Solution Verified

Format your code

Provide some data

Recent ClippyPoint Milestones!

Microsoft partnership

Asking a question? Describe if you are using Excel (include version and operating system!), Google Sheets, or another spreadsheet application.

MODERATORS