Ask Your Question
0

How do I update the date for each weekday when the weekdays are in fixed columns?

asked 2020-04-30 01:21:15 +0200

janthird gravatar image

I have a fixed set of seven columns for each day of the week...Monday through Sunday. I need to automatically update the current date for each day of the week. Using the Today() function and adding seven doesn't work in this case because the days of the week are fixed for each column, kind of like a planner week. Does anybody know how to do this easily? I have the feeling I am overlooking something simple.

edit retag flag offensive close merge delete

Comments

Is it a one month calendar?

JohnSUN gravatar imageJohnSUN ( 2020-04-30 06:09:01 +0200 )edit

Actually it is a legacy spreadsheet that covers one week. It is updated with activities, meetings, to do's, etc. which are entered in each row. I seems such a simple problem to automatically update the weekday dates, but I am having a hard time coming up with a good solution. I realize an integrated planner would probably be better but it is what it is and I am stuck with it at the moment.

janthird gravatar imagejanthird ( 2020-04-30 08:57:18 +0200 )edit

Do you mean that you need to display the dates of the current week? The one that includes TODAY()?

JohnSUN gravatar imageJohnSUN ( 2020-04-30 09:00:55 +0200 )edit

1 Answer

Sort by » oldest newest most voted
2

answered 2020-04-30 09:19:27 +0200

JohnSUN gravatar image

updated 2020-04-30 09:21:43 +0200

To first cell of week (for example B3)

=TODAY()-WEEKDAY(TODAY();3)

To next cell (C3)

=B3+1

and so on

And set format code as "NN, D MMMM"

edit flag offensive delete link more

Comments

Thank you! This worked perfectly.

janthird gravatar imagejanthird ( 2020-04-30 09:45:46 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2020-04-30 01:21:15 +0200

Seen: 34 times

Last updated: Apr 30