Recurring Tasks Calendar

udelgadochio

New Member
Joined
Dec 8, 2017
Messages
3
Hello you all!

I've been looking for a way to automate a calendar that I use and as of today I fill it manually.

It is a calendar of recurring tasks but they change through the weeks of the year.
For example I have tasks that are on mondays every 3 weeks.
Others that are monday, wednesday and friday every 2 weeks.
Others on tuesdays every week... and so on.

What I want to show is only the tasks for the current week but previously calculated so that I don't have to input them.

9g9dq8v.png


Is there any easy way to do this? I've spinning on my head several days by now and can't find the solution...
 

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.
@RasGhul is there any way you could repost your code. I'm having this exact same dilemma and any assistance would be so appreciated!
 
Upvote 0
Hi Sunny,

Note the Appointments table is an excel table.

Calendar Sheet_new.xlsm
ABCDE
1DateClientNotesMobileNext Booking
201/08/21Task1
301/08/21Task1
401/08/21Task1
501/08/21Task1
603/08/21Task1
703/08/21Task1
803/08/21Task7
903/08/21Task8
1007/08/21Task9
1107/08/21Task10
1207/08/21Task11
1307/08/21Task12
1407/08/21Task13
1507/08/21Task14
1607/08/21Task15
1707/08/21Task16
1818/08/21Task17
Appointments


Calendar Sheet_new.xlsm
ABCDEFGHIJ
1
2Today's Date31/08/2021
3Aug 2021
4
5SundayMondayTuesdayWednesdayThursdayFridaySaturday1st of Month1/08/2021
61/08/20212/08/20213/08/20214/08/20215/08/20216/08/20217/08/2021Weekday1
7Task1Task1Task9Month 18
8Task1Task1Task10Month 29
9Task1Task7Task11EOM Month 230/09/2021
10Task1Task8Task12
11Task13
12Task14
13Task15
14Task16
15
16
178/08/20219/08/202110/08/202111/08/202112/08/202113/08/202114/08/2021
Calendar
Cell Formulas
RangeFormula
B2B2=TODAY()
G3G3=G6
A5:G5B5=B6
A6:G6B6=COLUMNS($A$6:B6)-$J$6+$J$5
A7A7=IF(MONTH(A$6)<>$J$7,"",IF(ROWS(A$7:A7)>COUNTIFS(Salesdata[Date],A$6),"",INDEX(Salesdata[Client],SMALL(IF(Salesdata[Date]=A$6,ROW(Salesdata[Date])-ROW(Salesdata[#Headers])),ROWS(A$7:A7)))))
J5J5=EOMONTH($B$2,-1)+1
J6J6=WEEKDAY(J5,1)
J7J7=MONTH(J5)
J8J8=MONTH(EOMONTH($J$5,0)+1)
J9J9=EOMONTH(J5,1)
A17A17=G6+1
Press CTRL+SHIFT+ENTER to enter array formulas.
Cells with Conditional Formatting
CellConditionCell FormatStop If True
A6:G71Expression=MONTH(A6)<>$J$7textNO
 
Upvote 0

Forum statistics

Threads
1,224,820
Messages
6,181,157
Members
453,021
Latest member
Justyna P

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top