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
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).
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