Auto Populating Calendar Isssue

I have posted a number of calendars on this forum, which are all formula-based. They take data from a list of "events" (basically, date and description, but other fields can be added if required, including a date range), and display this on a monthly calendar where you can select the month and year from drop-downs. My original versions had up to 7 events per day, but I have amended this in a number of follow-up threads.

If you are interested, I can post links to some of the threads (or you could just search on the site for my user-name and "calendar").

Hope this helps.

Pete

Pete,
Thanks I have found one that I think can work. I have a question still though. The one I found has a good format I think. I am wanting to change a couple things but kinda tired of messing with it. Spent to much time on it as it is. I am needing to show when actual trial is set vs. requested. I can do this with a separate calendar file and then transfer in I think but was curious if there was a better way.
Thanks

I've amended the formulae so that you can do this automatically. Column C (of the DO NOT MESS WITH sheet) brings across the 'Requested Trial Date' (column I) from the Ledger sheet, and column D now contains the 'Date Request Submitted to Planner' from column J of the Ledger sheet. I've also arranged to show blanks where these occur in the Ledger sheet.

I no longer need the green formulae which were in columns G and I of the Data sheet.

I've changed the formulae in the blue columns so that there are now two records for each of your data items - one shows the Req_Date from column C and the other shows the Sub_Date from column D, and these alternate on different rows. I'm not sure which of these you class as "Actual trial" and which is "Requested", so I've continued to use Req and Sub from those headers. I've also amended the text in column L to show Req or Sub at the end, to distinguish between the date types.

You can see the effect on the Calendar sheet, so I hope this is the kind of thing you were after, as there is no need to have a duplicate calendar. Note that if the Req and Sub dates are in different months, then you won't be able to compare them directly.

Note also that you need twice as many records in the blue area compared with the table of data on the left, so ensure that the formulae are copied down far enough to cope with the amount of data that you have.

Hope this helps.

Pete

Pete,
Thanks again. I think it is really close when I get more time I think I know what I am going to try. The clutter in the sheet is what I am not really wanting so what I plan to do is write and IF statement for a separate cell to link back to one linking cell. So that lets say if Req is = to Actual/Sub than use Req, and if not use Sub. If Sub is 0 than use Req. This way I will only have one date for when trials are happening/requested.
Thanks again