How to manually create own calendar

[MyStix01]

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!

[tim201110]

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

[Fluff13]

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

[tim201110]

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

mine is shorter

[jason.b75]

Shorter would be

=$B$4-WEEKDAY($B$4)+COLUMNS($C5:C5)+ROW(C5)-5

Formatted as d

With a conditional format rule of

=MONTH(C5)<>MONTH($B$4)

used to format the font colour the same as the fill (background) colour, hiding the dates that don't fall into the required month.

Calendar needs an extra week as well (try it with 1/12/2018 in B4)

[jason.b75]

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.

[MyStix01]

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.

[Fluff13]

Glad we could help & thanks for the feedback