Calculate Next Occurrence (Date) Based on Varying Intervals

jpatchel

New Member
Joined
Feb 21, 2019
Messages
3
Hello,

This is my first post so I apologize ahead of time.

I was wondering if there is a formula that will calculate the next occurrence of a date based on different time lengths? I have found many solutions dealing with whole month intervals and weekly/biweekly intervals separately, but for my use, I need something that somehow combines the two. I am using this for a financial workbook, so there a few variables in date of payments/income (daily, weekly, biweekly, monthly, Quarterly, Semiannually, & Annually) that I am trying to calculate in the same table. There are start dates that are associated with each of these, however some have yet to occur.

Ultimately, my goal is to calculate the next several occurrences, but I'm convinced once I get this first one, the rest should follow suit, but I've been scratching my head over this for a while and thought to seek advice from some experts.

I have two tables below - A budget table and another table used for a data validation list. I was hoping to somehow use an index/match reference but I'm ultimately stumped. Please help. Thank you in advance!

Excel 2010
BCDEFGH
3FrequencyTableUserBudgetTable
4RecurrenceOccurrences Per Year
Category/Description
Budgeted AmountIntervalAssociated/Start Date
5Daily365Expense Category 06($50.00)Annually4/1/2019
6Weekly52Expense Category 27($200.00)Bimonthly1/1/2019
7Biweekly26Income Category 1$1,000.00 Biweekly1/11/2019
8Monthly12Income Category 2$1,000.00 Biweekly1/11/2019
9Bimonthly6Expense Category 03($1.00)Daily1/1/2019
10Quarterly4Expense Category 01($200.00)Monthly1/1/2019
12Annually1Expense Category 02($50.00)Monthly1/1/2019
14Expense Category 05($30.00)Monthly1/12/2019
16Expense Category 08($100.00)Monthly1/1/2019
20Expense Category 12($200.00)Monthly1/1/2019
21Expense Category 16($200.00)Monthly1/1/2019
22Expense Category 17($40.00)Monthly1/17/2019
23Expense Category 18($1,000.00)Monthly2/15/2019
26Expense Category 19($40.00)Monthly1/22/2019
27Expense Category 22($70.00)Monthly1/1/2019
28Expense Category 23($200.00)Monthly1/1/2019
31Expense Category 24($100.00)Monthly1/1/2019
33Expense Category 29($10.00)Monthly1/1/2019
34Expense Category 30($10.00)Monthly1/30/2019
36Expense Category 32($250.00)Monthly1/1/2019
37Expense Category 33($100.00)Monthly1/24/2019
38Expense Category 34($120.00)Monthly1/24/2019
41Expense Category 37($130.00)Monthly1/15/2019
42Expense Category 38($200.00)Monthly1/15/2019
43Expense Category 43($130.00)Monthly1/7/2019
44Expense Category 44($180.00)Monthly1/10/2019
47Expense Category 45($50.00)Monthly1/1/2019
48Expense Category 39($30.00)Quarterly2/1/2019
49Expense Category 40($40.00)Quarterly4/30/2019
50Expense Category 04($150.00)Semiannually1/1/2019
51Expense Category 10($40.00)Weekly2/1/2019
52Expense Category 46($10.00)Weekly1/1/2019
53

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
Budget
 

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).
Welcome

It seems to me further explanation is required. Exactly what result is expected where? Are there some samples?

Maybe a custom function (that is with programming, not standard excel functions available in the worksheet but a bespoke function written in VBA code) might be good. Would that be OK?

regards, Fazza
 
Upvote 0
Thank you Fazza.

I apologize for the lack of explanation. I guess I was trying not to overburden someone potentially looking at the post and in doing so it seems I missed explaining the whole point.

I am ultimately looking to create a dashboard of a financial snapshot.

I am looking to calculate the next occurrence of a budget category based on today() and the interval and start date. The first result would be in the table column immediately to the right of the "Associated/Start Date" column (n1) and then subsequent occurrences following (n2, n3, n4...). I would then use this data to create pivot tables/charts to display the upcoming budget items and a potential "forecast" of spending/income. I have manually entered the results I am hoping a formula would give me in the example below.

I am aware of how powerful VBA is, however, most of my excel knowledge is self taught/researched, and my work and personal scheduling conflicts don't allow me to explore as much as I would like to. I'm more of an excel hobbyist and greatly appreciate how amazing of a tool it can be. I would like to get into coding eventually, however, I don't know much of any at all at this point. I was hoping there was a solution that could use formulas. I hope I am not wasting anyone's time and greatly appreciate any help or guidance you can provide.


Excel 2010
ABCDEFGHIJKLMNO
1
2
3FrequencyTableUserBudgetTableNext Occurrence based on todays date
4RecurrenceOccurrences Per YearCategory/DescriptionBudgeted AmountIntervalAssociated/Start Daten1n2n3n4n5n6
5Daily365Expense Category 06($50.00)Annually4/1/20194/1/20204/1/20214/1/20224/1/20234/1/20244/1/2025
6Weekly52Expense Category 27($200.00)Bimonthly1/1/20197/1/20191/1/20207/1/20191/1/20207/1/20191/1/2020
7Biweekly26Income Category 1$1,000.00Biweekly1/11/20192/22/20193/8/20193/22/20194/5/20194/19/20195/3/2019
8Monthly12Income Category 2$1,000.00Biweekly1/11/20192/22/20193/8/20193/22/20194/5/20194/19/20195/3/2019
9Bimonthly6Expense Category 03($1.00)Daily1/1/20192/22/20192/23/20192/24/20192/25/20192/26/20192/27/2019
10Quarterly4Expense Category 01($200.00)Monthly1/1/20193/1/20194/1/20195/1/20196/1/20197/1/20198/1/2019
12Annually1Expense Category 02($50.00)Monthly1/1/20193/1/20194/1/20195/1/20196/1/20197/1/20198/1/2019
14Expense Category 05($30.00)Monthly1/12/20193/12/20194/12/20195/12/20196/12/20197/12/20198/12/2019
16Expense Category 08($100.00)Monthly1/1/20193/1/20194/1/20195/1/20196/1/20197/1/20198/1/2019
20Expense Category 12($200.00)Monthly1/1/20193/1/20194/1/20195/1/20196/1/20197/1/20198/1/2019
21Expense Category 16($200.00)Monthly1/1/20193/1/20194/1/20195/1/20196/1/20197/1/20198/1/2019
22Expense Category 17($40.00)Monthly1/17/20193/17/20194/17/20195/17/20196/17/20197/17/20198/17/2019
23Expense Category 18($1,000.00)Monthly2/15/20193/15/20194/15/20195/15/20196/15/20197/15/20198/15/2019
26Expense Category 19($40.00)Monthly1/22/20192/22/20193/22/20194/22/20195/22/20196/22/20197/22/2019
27Expense Category 22($70.00)Monthly1/1/20193/1/20194/1/20195/1/20196/1/20197/1/20198/1/2019
28Expense Category 23($200.00)Monthly1/1/20193/1/20194/1/20195/1/20196/1/20197/1/20198/1/2019
31Expense Category 24($100.00)Monthly1/1/20193/1/20194/1/20195/1/20196/1/20197/1/20198/1/2019
33Expense Category 29($10.00)Monthly1/1/20193/1/20194/1/20195/1/20196/1/20197/1/20198/1/2019
34Expense Category 30($10.00)Monthly1/30/20193/2/20194/2/20195/2/20196/2/20197/2/20198/2/2019
36Expense Category 32($250.00)Monthly1/1/20193/1/20194/1/20195/1/20196/1/20197/1/20198/1/2019
37Expense Category 33($100.00)Monthly1/24/20192/24/20193/24/20194/24/20195/24/20196/24/20197/24/2019
38Expense Category 34($120.00)Monthly1/24/20192/24/20193/24/20194/24/20195/24/20196/24/20197/24/2019
41Expense Category 37($130.00)Monthly1/15/20193/15/20194/15/20195/15/20196/15/20197/15/20198/15/2019
42Expense Category 38($200.00)Monthly1/15/20193/15/20194/15/20195/15/20196/15/20197/15/20198/15/2019
43Expense Category 43($130.00)Monthly1/7/20193/7/20194/7/20195/7/20196/7/20197/7/20198/7/2019
44Expense Category 44($180.00)Monthly1/10/20193/10/20194/10/20195/10/20196/10/20197/10/20198/10/2019
47Expense Category 45($50.00)Monthly1/1/20193/1/20194/1/20195/1/20196/1/20197/1/20198/1/2019
48Expense Category 39($30.00)Quarterly2/1/20195/1/20198/1/201911/1/20192/1/20205/1/20208/1/2020
49Expense Category 40($40.00)Quarterly4/30/20197/30/201910/30/20191/30/20204/30/20207/30/202010/30/2020
50Expense Category 04($150.00)Semiannually1/1/20197/1/20191/1/20207/1/20201/1/20217/1/20211/1/2022
51Expense Category 10($40.00)Weekly2/1/20192/22/20193/1/20193/8/20193/15/20193/22/20193/29/2019
52Expense Category 46($10.00)Weekly1/1/20192/26/20193/5/20193/12/20193/19/20193/26/20194/2/2019
53
Budget


Thank you,
Jason
 
Upvote 0
Changed your frequency table a bit, making it the number of days to add based on a 365 day year.
H2 contains, copied down.
Code:
=G2 + VLOOKUP(F2,$A:$B,2,FALSE)
I2 thru M2 contain the same formula, except G2 is replaced by the preceding cell, i.e. in I2 G2 becomes H2 but the rest remains the same.
Had to add Semiannually since that was also found in the interval column.

ABCDEFGHIJKLM
1TypeValueCategory/DescriptionBudgeted AmountIntervalStart Daten1n2n3n4n5n6
2Daily1Expense Category 06($50.00)Annually4/1/20193/31/20203/31/20213/31/20223/31/20233/30/20243/30/2025
3Weekly7Expense Category 27($200.00)Bimonthly1/1/20193/2/20195/2/20197/2/20199/1/201911/1/20191/1/2020
4BiWeekly14Income Category 1$1,000.00Biweekly1/11/20191/25/20192/8/20192/22/20193/8/20193/22/20194/5/2019
5Monthly30.41667Income Category 2$1,000.00Biweekly1/11/20191/25/20192/8/20192/22/20193/8/20193/22/20194/5/2019
6Bimonthly60.83333Expense Category 03($1.00)Daily1/1/20191/2/20191/3/20191/4/20191/5/20191/6/20191/7/2019
7Quarterly91.25Expense Category 01($200.00)Monthly1/1/20191/31/20193/2/20194/2/20195/2/20196/2/20197/2/2019
8Semiannually182.5Expense Category 02($50.00)Monthly1/1/20191/31/20193/2/20194/2/20195/2/20196/2/20197/2/2019
9Annually365Expense Category 05($30.00)Monthly1/12/20192/11/20193/13/20194/13/20195/13/20196/13/20197/13/2019
10Expense Category 08($100.00)Monthly1/1/20191/31/20193/2/20194/2/20195/2/20196/2/20197/2/2019
11Expense Category 12($200.00)Monthly1/1/20191/31/20193/2/20194/2/20195/2/20196/2/20197/2/2019
12Expense Category 16($200.00)Monthly1/1/20191/31/20193/2/20194/2/20195/2/20196/2/20197/2/2019
13Expense Category 17($40.00)Monthly1/17/20192/16/20193/18/20194/18/20195/18/20196/18/20197/18/2019
14Expense Category 18($1,000.00)Monthly2/15/20193/17/20194/16/20195/17/20196/16/20197/17/20198/16/2019
15Expense Category 19($40.00)Monthly1/22/20192/21/20193/23/20194/23/20195/23/20196/23/20197/23/2019
16Expense Category 22($70.00)Monthly1/1/20191/31/20193/2/20194/2/20195/2/20196/2/20197/2/2019
17Expense Category 23($200.00)Monthly1/1/20191/31/20193/2/20194/2/20195/2/20196/2/20197/2/2019
18Expense Category 24($100.00)Monthly1/1/20191/31/20193/2/20194/2/20195/2/20196/2/20197/2/2019
19Expense Category 29($10.00)Monthly1/1/20191/31/20193/2/20194/2/20195/2/20196/2/20197/2/2019
20Expense Category 30($10.00)Monthly1/30/20193/1/20193/31/20195/1/20195/31/20197/1/20197/31/2019
21Expense Category 32($250.00)Monthly1/1/20191/31/20193/2/20194/2/20195/2/20196/2/20197/2/2019
22Expense Category 33($100.00)Monthly1/24/20192/23/20193/25/20194/25/20195/25/20196/25/20197/25/2019
23Expense Category 34($120.00)Monthly1/24/20192/23/20193/25/20194/25/20195/25/20196/25/20197/25/2019
24Expense Category 37($130.00)Monthly1/15/20192/14/20193/16/20194/16/20195/16/20196/16/20197/16/2019
25Expense Category 38($200.00)Monthly1/15/20192/14/20193/16/20194/16/20195/16/20196/16/20197/16/2019
26Expense Category 43($130.00)Monthly1/7/20192/6/20193/8/20194/8/20195/8/20196/8/20197/8/2019
27Expense Category 44($180.00)Monthly1/10/20192/9/20193/11/20194/11/20195/11/20196/11/20197/11/2019
28Expense Category 45($50.00)Monthly1/1/20191/31/20193/2/20194/2/20195/2/20196/2/20197/2/2019
29Expense Category 39($30.00)Quarterly2/1/20195/3/20198/2/201911/1/20192/1/20205/2/20208/1/2020
30Expense Category 40($40.00)Quarterly4/30/20197/30/201910/29/20191/28/20204/29/20207/29/202010/28/2020
31Expense Category 04($150.00)Semiannually1/1/20197/2/20191/1/20207/1/202012/31/20207/1/202112/31/2021
32Expense Category 10($40.00)Weekly2/1/20192/8/20192/15/20192/22/20193/1/20193/8/20193/15/2019
33Expense Category 46($10.00)Weekly1/1/20191/8/20191/15/20191/22/20191/29/20192/5/20192/12/2019

<tbody>
</tbody>
 
Upvote 0
Thank you GR for your help. I had looked into something along those lines early on, but was hoping to have column [n1] be the next occurrent based on "today's date" and then columns [n2]-[n6] be the subsequent dates based on the interval. And yes, I apologize for my previous post - I had some things filtered on one of the tables and it hid some of the values.

I have attached one of my early attempts at this before posting. The issue is that the formulas are different for each interval type and manaully entered, independent of the [Interval] column, making it useless for what I was trying to do. I guess I am almost looking for an index/match solution on which formula to use, but I have no clue if that is even possible. I could do an if() solution, but I know that isn't as dynamic as I was hoping, and seems very messy.

I hope I am not being too bothersome and greatly appreciate any help offered.

Excel 2010
BCDEFGHIJKLMN
3FrequencyTableUserBudgetTableNext Occurrence based on todays date
4RecurrenceOccurrences Per YearCategory/DescriptionBudgeted AmountIntervalAssociated/Start Daten1n2n3n4n5n6
5Daily365Expense Category 06($50.00)Annually4/1/20194/1/20204/1/20214/1/20224/1/20234/1/20244/1/2025
6Weekly52Expense Category 27($200.00)Bimonthly1/1/20193/1/20195/1/20197/1/20199/1/201911/1/20191/1/2020
7Biweekly26Income Category 1$1,000.00Biweekly1/4/20193/1/20193/15/20193/29/20194/12/20194/26/20195/10/2019
8Monthly12Income Category 2$1,000.00Biweekly1/11/20193/8/20193/22/20194/5/20194/19/20195/3/20195/17/2019
9Bimonthly6Expense Category 03($1.00)Daily1/1/20192/26/20192/27/20192/28/20193/1/20193/2/20193/3/2019
10Quarterly4Expense Category 01($200.00)Monthly1/1/20193/1/20194/1/20195/1/20196/1/20197/1/20198/1/2019
11Semiannually2Expense Category 02($50.00)Monthly1/1/20193/1/20194/1/20195/1/20196/1/20197/1/20198/1/2019
12Annually1Expense Category 05($30.00)Monthly1/12/20193/12/20194/12/20195/12/20196/12/20197/12/20198/12/2019
13Expense Category 08($100.00)Monthly1/1/20193/1/20194/1/20195/1/20196/1/20197/1/20198/1/2019
14Expense Category 12($200.00)Monthly1/1/20193/1/20194/1/20195/1/20196/1/20197/1/20198/1/2019
15Expense Category 16($200.00)Monthly1/1/20193/1/20194/1/20195/1/20196/1/20197/1/20198/1/2019
16Expense Category 17($40.00)Monthly1/17/20193/17/20194/17/20195/17/20196/17/20197/17/20198/17/2019
17Expense Category 18($1,000.00)Monthly2/15/20193/15/20194/15/20195/15/20196/15/20197/15/20198/15/2019
18Expense Category 19($40.00)Monthly1/22/20193/22/20194/22/20195/22/20196/22/20197/22/20198/22/2019
19Expense Category 22($70.00)Monthly1/1/20193/1/20194/1/20195/1/20196/1/20197/1/20198/1/2019
20Expense Category 23($200.00)Monthly1/1/20193/1/20194/1/20195/1/20196/1/20197/1/20198/1/2019
21Expense Category 24($100.00)Monthly1/1/20193/1/20194/1/20195/1/20196/1/20197/1/20198/1/2019
22Expense Category 29($10.00)Monthly1/1/20193/1/20194/1/20195/1/20196/1/20197/1/20198/1/2019
23Expense Category 30($10.00)Monthly1/30/20193/2/20193/2/20193/2/20193/2/20193/2/20193/2/2019
24Expense Category 32($250.00)Monthly1/1/20193/1/20194/1/20195/1/20196/1/20197/1/20198/1/2019
25Expense Category 33($100.00)Monthly1/24/20193/24/20194/24/20195/24/20196/24/20197/24/20198/24/2019
26Expense Category 34($120.00)Monthly1/24/20193/24/20194/24/20195/24/20196/24/20197/24/20198/24/2019
27Expense Category 37($130.00)Monthly1/15/20193/15/20194/15/20195/15/20196/15/20197/15/20198/15/2019
28Expense Category 38($200.00)Monthly1/15/20193/15/20194/15/20195/15/20196/15/20197/15/20198/15/2019
29Expense Category 43($130.00)Monthly1/7/20193/7/20194/7/20195/7/20196/7/20197/7/20198/7/2019
30Expense Category 44($180.00)Monthly1/10/20193/10/20194/10/20195/10/20196/10/20197/10/20198/10/2019
31Expense Category 45($50.00)Monthly1/1/20193/1/20194/1/20195/1/20196/1/20197/1/20198/1/2019
32Expense Category 39($30.00)Quarterly2/1/20195/1/20198/1/201911/1/20192/1/20205/1/20208/1/2020
33Expense Category 40($40.00)Quarterly4/30/20197/30/201910/30/20191/30/20204/30/20207/30/202010/30/2020
34Expense Category 04($150.00)Semiannually1/1/20197/1/20191/1/20207/1/20201/1/20217/1/20211/1/2022
35Expense Category 10($40.00)Weekly2/1/20193/1/20193/8/20193/15/20193/22/20193/29/20194/5/2019
36Expense Category 46($10.00)Weekly1/1/20192/26/20193/5/20193/12/20193/19/20193/26/20194/2/2019

<tbody>
</tbody>
Budget

Worksheet Formulas
CellFormula
I5=EDATE(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]],CEILING(DATEDIF(MIN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]],TODAY()),MAX(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]],TODAY()),"m")+1,(COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))*12))
J5=EDATE(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]],CEILING(DATEDIF(MIN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]],TODAY()),MAX(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]],TODAY()),"m")+1,(COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))*12))
K5=EDATE(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]],CEILING(DATEDIF(MIN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]],TODAY()),MAX(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]],TODAY()),"m")+1,(COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))*12))
L5=EDATE(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]],CEILING(DATEDIF(MIN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]],TODAY()),MAX(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]],TODAY()),"m")+1,(COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))*12))
M5=EDATE(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]],CEILING(DATEDIF(MIN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]],TODAY()),MAX(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]],TODAY()),"m")+1,(COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))*12))
N5=EDATE(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]],CEILING(DATEDIF(MIN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]],TODAY()),MAX(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]],TODAY()),"m")+1,(COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))*12))
I6=EDATE(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]],CEILING(DATEDIF(MIN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]],TODAY()),MAX(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]],TODAY()),"m")+1,(COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))*2))
J6=EDATE(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]],CEILING(DATEDIF(MIN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]],TODAY()),MAX(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]],TODAY()),"m")+1,(COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))*2))
K6=EDATE(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]],CEILING(DATEDIF(MIN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]],TODAY()),MAX(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]],TODAY()),"m")+1,(COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))*2))
L6=EDATE(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]],CEILING(DATEDIF(MIN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]],TODAY()),MAX(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]],TODAY()),"m")+1,(COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))*2))
M6=EDATE(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]],CEILING(DATEDIF(MIN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]],TODAY()),MAX(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]],TODAY()),"m")+1,(COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))*2))
N6=EDATE(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]],CEILING(DATEDIF(MIN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]],TODAY()),MAX(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]],TODAY()),"m")+1,(COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))*2))
I7=MOD(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]-TODAY(),14)+TODAY()+(14*((COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))-1))
J7=MOD(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]-TODAY(),14)+TODAY()+(14*((COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))-1))
K7=MOD(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]-TODAY(),14)+TODAY()+(14*((COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))-1))
L7=MOD(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]-TODAY(),14)+TODAY()+(14*((COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))-1))
M7=MOD(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]-TODAY(),14)+TODAY()+(14*((COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))-1))
N7=MOD(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]-TODAY(),14)+TODAY()+(14*((COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))-1))
I8=MOD(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]-TODAY(),14)+TODAY()+(14*((COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))-1))
J8=MOD(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]-TODAY(),14)+TODAY()+(14*((COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))-1))
K8=MOD(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]-TODAY(),14)+TODAY()+(14*((COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))-1))
L8=MOD(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]-TODAY(),14)+TODAY()+(14*((COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))-1))
M8=MOD(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]-TODAY(),14)+TODAY()+(14*((COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))-1))
N8=MOD(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]-TODAY(),14)+TODAY()+(14*((COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))-1))
I9=(TODAY()+(COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]])))-1
J9=(TODAY()+(COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]])))-1
K9=(TODAY()+(COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]])))-1
L9=(TODAY()+(COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]])))-1
M9=(TODAY()+(COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]])))-1
N9=(TODAY()+(COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]])))-1
I10=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
J10=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
K10=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
L10=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
M10=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
N10=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
I11=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
J11=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
K11=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
L11=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
M11=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
N11=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
I12=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
J12=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
K12=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
L12=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
M12=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
N12=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
I13=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
J13=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
K13=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
L13=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
M13=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
N13=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
I14=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
J14=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
K14=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
L14=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
M14=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
N14=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
I15=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
J15=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
K15=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
L15=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
M15=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
N15=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
I16=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
J16=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
K16=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
L16=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
M16=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
N16=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
I17=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
J17=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
K17=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
L17=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
M17=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
N17=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
I18=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
J18=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
K18=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
L18=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
M18=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
N18=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
I19=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
J19=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
K19=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
L19=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
M19=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
N19=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
I20=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
J20=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
K20=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
L20=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
M20=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
N20=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
I21=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
J21=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
K21=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
L21=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
M21=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
N21=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
I22=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
J22=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
K22=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
L22=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
M22=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
N22=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
I23=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
J23=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
K23=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
L23=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
M23=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
N23=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
I24=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
J24=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
K24=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
L24=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
M24=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
N24=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
I25=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
J25=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
K25=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
L25=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
M25=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
N25=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
I26=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
J26=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
K26=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
L26=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
M26=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
N26=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
I27=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
J27=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
K27=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
L27=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
M27=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
N27=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
I28=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
J28=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
K28=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
L28=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
M28=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
N28=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
I29=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
J29=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
K29=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
L29=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
M29=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
N29=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
I30=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
J30=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
K30=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
L30=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
M30=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
N30=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
I31=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
J31=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
K31=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
L31=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
M31=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
N31=DATE(YEAR(NOW()),MONTH(NOW())+(IF(DAY(NOW())>DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),0)), DAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))
I32=EDATE(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]],CEILING(DATEDIF(MIN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]],TODAY()),MAX(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]],TODAY()),"m")+1,(COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))*3))
J32=EDATE(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]],CEILING(DATEDIF(MIN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]],TODAY()),MAX(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]],TODAY()),"m")+1,(COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))*3))
K32=EDATE(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]],CEILING(DATEDIF(MIN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]],TODAY()),MAX(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]],TODAY()),"m")+1,(COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))*3))
L32=EDATE(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]],CEILING(DATEDIF(MIN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]],TODAY()),MAX(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]],TODAY()),"m")+1,(COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))*3))
M32=EDATE(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]],CEILING(DATEDIF(MIN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]],TODAY()),MAX(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]],TODAY()),"m")+1,(COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))*3))
N32=EDATE(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]],CEILING(DATEDIF(MIN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]],TODAY()),MAX(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]],TODAY()),"m")+1,(COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))*3))
I33=EDATE(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]],CEILING(DATEDIF(MIN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]],TODAY()),MAX(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]],TODAY()),"m")+1,(COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))*3))
J33=EDATE(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]],CEILING(DATEDIF(MIN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]],TODAY()),MAX(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]],TODAY()),"m")+1,(COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))*3))
K33=EDATE(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]],CEILING(DATEDIF(MIN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]],TODAY()),MAX(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]],TODAY()),"m")+1,(COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))*3))
L33=EDATE(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]],CEILING(DATEDIF(MIN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]],TODAY()),MAX(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]],TODAY()),"m")+1,(COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))*3))
M33=EDATE(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]],CEILING(DATEDIF(MIN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]],TODAY()),MAX(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]],TODAY()),"m")+1,(COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))*3))
N33=EDATE(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]],CEILING(DATEDIF(MIN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]],TODAY()),MAX(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]],TODAY()),"m")+1,(COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))*3))
I34=EDATE(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]],CEILING(DATEDIF(MIN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]],TODAY()),MAX(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]],TODAY()),"m")+1,(COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))*6))
J34=EDATE(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]],CEILING(DATEDIF(MIN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]],TODAY()),MAX(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]],TODAY()),"m")+1,(COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))*6))
K34=EDATE(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]],CEILING(DATEDIF(MIN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]],TODAY()),MAX(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]],TODAY()),"m")+1,(COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))*6))
L34=EDATE(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]],CEILING(DATEDIF(MIN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]],TODAY()),MAX(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]],TODAY()),"m")+1,(COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))*6))
M34=EDATE(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]],CEILING(DATEDIF(MIN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]],TODAY()),MAX(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]],TODAY()),"m")+1,(COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))*6))
N34=EDATE(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]],CEILING(DATEDIF(MIN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]],TODAY()),MAX(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]],TODAY()),"m")+1,(COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))*6))
I35=DATE(YEAR(NOW()),MONTH(NOW()),DAY(NOW()))-WEEKDAY(NOW())+(IF(WEEKDAY(NOW())>WEEKDAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),7,0))+ WEEKDAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]])+(((COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))-1)*7)
J35=DATE(YEAR(NOW()),MONTH(NOW()),DAY(NOW()))-WEEKDAY(NOW())+(IF(WEEKDAY(NOW())>WEEKDAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),7,0))+ WEEKDAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]])+(((COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))-1)*7)
K35=DATE(YEAR(NOW()),MONTH(NOW()),DAY(NOW()))-WEEKDAY(NOW())+(IF(WEEKDAY(NOW())>WEEKDAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),7,0))+ WEEKDAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]])+(((COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))-1)*7)
L35=DATE(YEAR(NOW()),MONTH(NOW()),DAY(NOW()))-WEEKDAY(NOW())+(IF(WEEKDAY(NOW())>WEEKDAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),7,0))+ WEEKDAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]])+(((COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))-1)*7)
M35=DATE(YEAR(NOW()),MONTH(NOW()),DAY(NOW()))-WEEKDAY(NOW())+(IF(WEEKDAY(NOW())>WEEKDAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),7,0))+ WEEKDAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]])+(((COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))-1)*7)
N35=DATE(YEAR(NOW()),MONTH(NOW()),DAY(NOW()))-WEEKDAY(NOW())+(IF(WEEKDAY(NOW())>WEEKDAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),7,0))+ WEEKDAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]])+(((COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))-1)*7)
I36=DATE(YEAR(NOW()),MONTH(NOW()),DAY(NOW()))-WEEKDAY(NOW())+(IF(WEEKDAY(NOW())>WEEKDAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),7,0))+ WEEKDAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]])+(((COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))-1)*7)
J36=DATE(YEAR(NOW()),MONTH(NOW()),DAY(NOW()))-WEEKDAY(NOW())+(IF(WEEKDAY(NOW())>WEEKDAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),7,0))+ WEEKDAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]])+(((COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))-1)*7)
K36=DATE(YEAR(NOW()),MONTH(NOW()),DAY(NOW()))-WEEKDAY(NOW())+(IF(WEEKDAY(NOW())>WEEKDAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),7,0))+ WEEKDAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]])+(((COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))-1)*7)
L36=DATE(YEAR(NOW()),MONTH(NOW()),DAY(NOW()))-WEEKDAY(NOW())+(IF(WEEKDAY(NOW())>WEEKDAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),7,0))+ WEEKDAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]])+(((COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))-1)*7)
M36=DATE(YEAR(NOW()),MONTH(NOW()),DAY(NOW()))-WEEKDAY(NOW())+(IF(WEEKDAY(NOW())>WEEKDAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),7,0))+ WEEKDAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]])+(((COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))-1)*7)
N36=DATE(YEAR(NOW()),MONTH(NOW()),DAY(NOW()))-WEEKDAY(NOW())+(IF(WEEKDAY(NOW())>WEEKDAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]),7,0))+ WEEKDAY(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]])+(((COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))-1)*7)

<tbody>
</tbody>

<tbody>
</tbody>



Thank you,

Jason
 
Upvote 0
Wow, significant work to get to the expected date i.e. 1/4/2019 + 365.25 will be 1/4/2019 instead of 31/3/2020, because next year is a leap year. Spent all of lunch break trying to figure that out and ran out of time.
This does work for the calculations of using today if today is greater than the next calculated interval:
In H2 (column n1) you can put this formula and copy down. Column B is still the number of days of the interval (Daily=1, Annually=365.25)
=IF(NOW() > G2 + VLOOKUP(F2,A:B,2,FALSE),NOW() + VLOOKUP(F2,A:B,2,FALSE),G2 + VLOOKUP(F2,A:B,2,FALSE))
In I2 thru M2 you can put the below where X is H thru L, and then copy down.
=X2 + VLOOKUP(F2,A:B,2,FALSE)
 
Last edited:
Upvote 0

Forum statistics

Threads
1,214,998
Messages
6,122,639
Members
449,093
Latest member
Ahmad123098

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