trowa

asked on

# Autopopulate a calendar?

I got a requirement to auto-populate an Excel with Calendar based on a Date's value (let's say A1)

So, if A1 = 1 Nov 2017, the excel should auto-populate a calendar in Nov 17; same if A1 = 1 Dec 2017, the excel should auto-populate a calendar in Dec 17, and so forth.

Is that possible by using pure Excel formula? I don't need a complex solution here.

Thank you.

test1.xlsx

So, if A1 = 1 Nov 2017, the excel should auto-populate a calendar in Nov 17; same if A1 = 1 Dec 2017, the excel should auto-populate a calendar in Dec 17, and so forth.

Is that possible by using pure Excel formula? I don't need a complex solution here.

Thank you.

test1.xlsx

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER

Thank you both, very nice solutions!

You're welcome Trowa! Glad we could help.

=IF(WEEKDAY(A1,1)=2,A1,FLO

You can then use =B15+1 in C15 and copied across to F15

Then use =B15+7 in B16 and copied across and down to F19.

You can then use Conditional formatting to ensure that surplus days prior to 1st of month or after end of month are formatted as white font on white background with this formula:

=OR(B15<$A$1,B15>EOMONTH($

I will upload a sample shortly.