Hi All,
I’d much appreciate your guidance on how to create acalendar which would auto-populate activities per day based on conditions.
I’ve done some Googling but cannot find exactly what I’mafter
1, I’d use one of the Excel Calendar Templates which updatesdates automatically based on chosen month.
2, I’d like to have a list of public holidays on a separate taband have these days automatically highlighted in the calendar page.
3, I’d like to have some activities auto-populated in therespective days.
For example as below: the yellow highlighted items would beregular based on day during the week except some days
The green item must be done at a specific day.
<tbody>
</tbody>
4, When there is a public holiday if any activities fall onthat day I’d like to have them automatically moved to the day before if notweekend.
Ok – I think it sounds almost impossible to create this at least with my current knowledge but I thoughtI’ll try my luck. Also, I'd prefer not to use Macros/VBAs but it might not be possible (?), I'm not sure
Many thanks in advance for your opinion, Laura
I’d much appreciate your guidance on how to create acalendar which would auto-populate activities per day based on conditions.
I’ve done some Googling but cannot find exactly what I’mafter
1, I’d use one of the Excel Calendar Templates which updatesdates automatically based on chosen month.
2, I’d like to have a list of public holidays on a separate taband have these days automatically highlighted in the calendar page.
3, I’d like to have some activities auto-populated in therespective days.
For example as below: the yellow highlighted items would beregular based on day during the week except some days
The green item must be done at a specific day.
| Time | Activity | Frequency |
| Mon-Fri | Activity A | Always except second working day of month |
| Every Thursday | Activity B | Every Thursday except if Thursday is second working of month |
| Every second Wednesday in a month | Activity C | Every second Wednesday in a month except it's first working day of month |
| Every second working day of month | Activity D | Only at first working day of a month |
4, When there is a public holiday if any activities fall onthat day I’d like to have them automatically moved to the day before if notweekend.
Ok – I think it sounds almost impossible to create this at least with my current knowledge but I thoughtI’ll try my luck. Also, I'd prefer not to use Macros/VBAs but it might not be possible (?), I'm not sure
Many thanks in advance for your opinion, Laura
Last edited by a moderator:
