Calendar based on Month selected

[richblake74]

Hello all,
A1 on sheet Log, will be a Month and Year only (Mar 2019)
A2 Should be first day of the month selected in A1,
Col A will have all the next dates of the month until the last 31st

But what I would like is if I select Feb 2019 in A1
all the col A fill up until the 28th Feb (Cell A29) A30 should be blank and A31 should also be blank.
Can someone help please.


Cheers

 

[Kenneth Hobson]

A2= =A1, set custom number format to 2.
A3= =IFERROR(IF(MONTH(A$1)=MONTH(A2+1), A2+1,""),""), and fill down to A31.

 

[richblake74]

Perfect thank you very much