Calendar based on Month selected

richblake74

Active Member
Joined
Dec 30, 2006
Messages
280
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

Well-known Member
Joined
Feb 6, 2007
Messages
3,092
A2= =A1, set custom number format to 2.
A3= =IFERROR(IF(MONTH(A$1)=MONTH(A2+1), A2+1,""),""), and fill down to A31.
 

Forum statistics

Threads
1,085,960
Messages
5,386,957
Members
402,026
Latest member
rudyd06

Some videos you may like

This Week's Hot Topics

Top