Forum

Notifications
Clear all

How to change date

3 Posts
3 Users
0 Reactions
94 Views
(@mydilemma)
Posts: 1
New Member
Topic starter
 

Hi,

This is something for work. I'd like to change cell B3 every year and I would like that the dates in the other cells change automaticly. At the top it are the names of the days (from monday to sunday) these are not changeable (I had this, but do not like it that way).

Is this possible?

I added an example in attachments.

I don't know what version we have at work, it's on windows.

 

Thank you in advance.

 

Greetings Sven

 
Posted : 06/04/2022 2:35 pm
(@jstewart)
Posts: 216
Estimable Member
 

Honestly, I would do this with a helper cell. Somewhere in your workbook have a cell with the year, you could either change it manually each year or use the formula =YEAR(today()) to extract the current year, then simply reference that cell for your dates. So instead of manually entering dates, you would use the date formula eg: =DATE(cellYear,9,22).

 
Posted : 07/04/2022 10:35 am
Anders Sehlstedt
(@sehlsan)
Posts: 970
Prominent Member
 

Hello,

See attached file for an example.

Type in (or paste) the below nested IF formula in cell C3, then drag and copy to the remaining cells.

=IF(AND(ROW(C3)=3,WEEKDAY($B$3,2)=COLUMNS($C$1:C$1)),$B$3,
IF(AND(COLUMNS($C$1:C$1)=1,$I2<>""),$I2+1,
IF(AND(COLUMNS($C$1:C$1)>1;B3<>""),B3+1,"")))

Br,
Anders

 
Posted : 07/04/2022 2:26 pm
Share: