How to manually create own calendar

Hi,

I'm not sure if this is possible, but I've been trying to create my own calendar.

So attached is the spreadsheet and format I have created.

Basically I just need a formula under the highlighted cells that will automatically feed in the dates for the month.

So ex. If I like input the month I'm currently in under cell B4, the formulas on the highlighted cells should then be able to automatically populate by being able to identify as to which day the first day of the month would fall, and which day of the month it will end.

Hope this makes sense and I hope this is really possible. Thank you! Thank you!

=sumproduct(--(month(date($a$2,$a$3,row($1:$31)))=$a$3),--(day(date($a$2,$a$3,row($1:$31)))=(column()-2+7*(ceiling(row()/$a$1,1)-1)-choose(weekday(date($a$2,$a$3,)),1,2,3,4,5,6,))),day(date($a$2,$a$3,row($1:$31))))

I'm sure there must be a simpler way, but this seems to work

http://spreadsheetpage.com/index.php...ndar_workbook/

mine is shorter

Without the custom formatting, I think this will be about the simplest generic formula.

In C5, then drag right and copy down as needed.

=IFERROR(1/(1/TEXT(-WEEKDAY($B$4)+COLUMNS($C5:C5)+ROW(C5)-4,"[>"&DAY(EOMONTH($B$4,0))&"]\0;\0;0")),"")

Note that only the rows for weeks 1, 5 and 6 need the full formula, although it will work correctly in the rows for weeks 2, 3 and 4, simply using =I5+1 in C12, then =C12+1 in D12, etc will suffice.

Hi All,

Thank you all for the responses and the effort. Appreciate it very much. Surprised to see that there's actually lot of ways to do this. I've tried you formulas and everything works perfectly, guess I'd just have to choose one that is more straightforward. Thank you all. Godbless.

Glad we could help & thanks for the feedback