Solved Is there a way to skip lines in an array formula calendar

August 25, 2014 at 21:26:36
Specs: Windows 7
I have created an array calendar in Excel and would like to have multiple lines under each day to be able to add text data to. Currently the calendar is laid out:

Sun Mon Tues Wed Thurs Fri Sat
1 2 3 4 5 6
7 8 9 10 11 12 13

But I want it to be:

Sun Mon Tues Wed Thurs Fri Sat
1 2 3 4 5 6
Rows/Cells for Text
Rows/Cells for Text
7 8 9 10 11 12 13
Rows/Cells for Text
Rows/Cells for Text

Below is the formula I have used to set up my array calendar:

9/1/2014
9/1/2014 (Month Start Date) (A4)
2 (Starts on a Monday) (A5)
9 (9th Month) (A6)


=IF(MONTH(COLUMNS($D5:D5)+(ROWS(D$5:D5)-1)*7-$A$5+$A$4)=$A$6,COLUMNS($D5:D5)+(ROWS(D$5:D5)-1)*7-$A$5+$A$4,"")

D5 is the first date block on the calendar

Thank you in advance for any help you might be able to provide!!


See More: Is there a way to skip lines in an array formula calendar

Report •


#1
August 26, 2014 at 04:01:44

First, a posting tip:

Please click on the blue line at the end of this post and read the instructions on how to format example data so that it is easier for us to read. Then edit/repost your data so that the columns line up correctly. Don't forget to use Column letters and Row numbers as shown in the example.

Thanks!

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
August 26, 2014 at 12:49:27
✔ Best Answer
Why reinvent the wheel -
Look here for a ready made template.

https://office.microsoft.com/en-us/...

Shows Day of Week and Date and uses one expanded row for notes.

You may need to Format the notes row so it Word Wraps and is Top Justified.

MIKE

http://www.skeptic.com/


Report •

#3
August 26, 2014 at 21:27:52
Thank you kindly for taking the time to respond!! I appreciate the link to the calendar templates. I found the formula reference I was looking for on one of the calendars and should be good to go. :)

Report •

Related Solutions

#4
August 26, 2014 at 21:28:50
Thank you, I found what I was looking for! :)

Report •

Ask Question