Forum Discussion
Help with formula for different length months in accounting worksheet
I'm having the days of the month autofill but I don't know how to have it stop for months that have fewer days e.x. 28,29,30,31. I need it to be able to divide the profit margin by the d...
Well i don't know how you have "the days of the month autofill"
I recommend have a Start Date and then you have Total Days in Month based on:
=DAY(EOMONTH(startdate, 0))
Then you can 'autofill' in C19 using =startdate + SEQUENCE(1,B17,0)
I recommend have a Start Date and then you have Total Days in Month based on:
=DAY(EOMONTH(startdate, 0))
Then you can 'autofill' in C19 using =startdate + SEQUENCE(1,B17,0)
