Log In
Register
Home
New Member
April 6, 2022
Offline
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
See Answer
Trusted Members
February 13, 2021
Offline
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).
VIP
Trusted Members
December 7, 2016
Offline
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
Answers Post
1 Guest(s)
