D
Danny
I am trying to make a calendar that is 7 columns wide by 12 rows tall. The
seven columns are days of the week. The top row is the month. The next row
is labeled Sunday through Saturday. Then for each day there are 2 blocks.
One with the day of month and the one directly below it is blank. I have a
list (either a separate sheet or a separate saved file entirely) that is two
columns by 365 rows. The first column goes from Jan 1 to Dec 31. The other
column has important dates (holidays, birthdays, appointments, etc)
I want to be able to have the blank block under the date in my calendar to
lookup the date in this list and return the event happening that day (if any)
in the blank block. But if there is no event I do not want it to return a 0.
I want it to return a "".
I am working on this by creating my own function(LOOKUPDATE) that looks up
the date (formatted as a date but only showing the day (dd) not (mm/dd/yyyy)
in the block above and returning the text. But if there is a easier way pleas
let me know.
I would like to know how to either create a third column in my list or
someway that I can have a picture (or picture location (c:\pictures.jpg) to
be placed in the same block as the text. For example: For thanksgiving I
want to be able to look up 11/27 and return in the block below it "Happy
Thanksgiving" and a pic of a Turkey.
Please help... I have made a calendar like this and printed it the last
couple years for my grandmother so she can look at it for birthdays, holidays
and other important dates but it takes quite some time to go through and add
all the pictures and text to each block that needs it. I was thinking it
would be easier to create a list and just change the days on the calendar
each year and everything else update itself. Rather than needing to manually
change everything.
This was quite long but I appreciate your time and am grateful for any help.
seven columns are days of the week. The top row is the month. The next row
is labeled Sunday through Saturday. Then for each day there are 2 blocks.
One with the day of month and the one directly below it is blank. I have a
list (either a separate sheet or a separate saved file entirely) that is two
columns by 365 rows. The first column goes from Jan 1 to Dec 31. The other
column has important dates (holidays, birthdays, appointments, etc)
I want to be able to have the blank block under the date in my calendar to
lookup the date in this list and return the event happening that day (if any)
in the blank block. But if there is no event I do not want it to return a 0.
I want it to return a "".
I am working on this by creating my own function(LOOKUPDATE) that looks up
the date (formatted as a date but only showing the day (dd) not (mm/dd/yyyy)
in the block above and returning the text. But if there is a easier way pleas
let me know.
I would like to know how to either create a third column in my list or
someway that I can have a picture (or picture location (c:\pictures.jpg) to
be placed in the same block as the text. For example: For thanksgiving I
want to be able to look up 11/27 and return in the block below it "Happy
Thanksgiving" and a pic of a Turkey.
Please help... I have made a calendar like this and printed it the last
couple years for my grandmother so she can look at it for birthdays, holidays
and other important dates but it takes quite some time to go through and add
all the pictures and text to each block that needs it. I was thinking it
would be easier to create a list and just change the days on the calendar
each year and everything else update itself. Rather than needing to manually
change everything.
This was quite long but I appreciate your time and am grateful for any help.