I want to arrange all the columns to be automatic according to the starting point, meaning - there is a line where I enter a date for example 1/3/2024 and I want all the following columns to be automatically calculated according to the month I entered, the next column will automatically switch to 1/4/2024 and the next column will automatically switch to 1/ 5/2024 and so on
What is the formula? Or the code that does it?
Hallo
If your »startdate« is in A1, enter into B1:
=EOMONTH(A1;0)+1
and pull to right…
1 Like