Add one to day of week

[mjones]

Hi All,

If I have Sunday in A3, I'd like another cell (A10) to automatically be Monday by adding a day to Sunday in A3. Then, Tuesday will be in A17, Wednesday A24, etc. for A31, A38 & A45.

Thus, when I change A3 to the day of the week, the cells below will sequentially be the correct weekday.

Any ideas?

Thanks,

Michele

 

[PeteWright]

A few questions:

1. Are the cells in your table bound to dates (eg. Sunday, 24.09.2023) or is it text-only (like "Sunday")?
   - with dates you could set up a cell to show only the weekday and automatically calculate/populate the whole table with formulas
2. Is this a one-time task (eg. automatically fill a table with weekdays at specific positions) or, for example, an "interactive" table?
   - as a one-time task you could use a macro or VBA to populate the cells

 

[awoohaw]

Just use regular dates and format the cells as "ddd" or however you want.

Mr excel questions 64.xlsm
	A
1
2
3	Sun 09-24
4
5
6
7
8
9
10	Mon 09-25
11
12
13
14
15
16
17	Tue 09-26
18
19
20
21
22
23
24	Wed 09-27
25
26
27
28
29
30
31	Thu 09-28
32
33
34
35
36
37
38	Fri 09-29
39
40
41
42
43
44
45	Sat 09-30
46
47
Sheet6

Cell Formulas
Range	Formula
A10,A45,A38,A31,A24,A17	A10	=A3+1

 

[mjones]

Thank you Awoohaw. That worked.

​

PeteWright, thank you as well. It's something I do every week and I have to type the dates in 14 times. Now I only have to type one date and they all populate.

Thanks again!

 

[awoohaw]

Thank you Awoohaw. That worked.

​

PeteWright, thank you as well. It's something I do every week and I have to type the dates in 14 times. Now I only have to type one date and they all populate.

Thanks again!

I happy you found a solution here.

Best Wishes!

 

[kweaver]

Another possible option would be to put a zero (0) in A4:A9.
Then, in A10 put: =1+A3
Select A3:A10 and fill down.
With the complete range selected, use Custom Format: dddd;;; which will display the day of the week but suppress the zeros.

 

[awoohaw]

Another possible option would be to put a zero (0) in A4:A9.
Then, in A10 put: =1+A3
Select A3:A10 and fill down.
With the complete range selected, use Custom Format: dddd;;; which will display the day of the week but suppress the zeros.

You can also do that by just selecting cells A4 to A10 and dragging down
(with the Sunday in A3 and A3+1 in A10). You do not need to do the suppressed zeros formatting, just "ddd" or whatever the user wants.