Calculate Next Occurrence (Date) Based on Varying Intervals

J

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
FrequencyTableUserBudgetTable
RecurrenceOccurrences Per Year
Category/Description
Budgeted AmountIntervalAssociated/Start Date
DailyExpense Category 06Annually
WeeklyExpense Category 27Bimonthly
BiweeklyIncome Category 1Biweekly
MonthlyIncome Category 2Biweekly
BimonthlyExpense Category 03Daily
QuarterlyExpense Category 01Monthly
AnnuallyExpense Category 02Monthly
Expense Category 05Monthly
Expense Category 08Monthly
Expense Category 12Monthly
Expense Category 16Monthly
Expense Category 17Monthly
Expense Category 18Monthly
Expense Category 19Monthly
Expense Category 22Monthly
Expense Category 23Monthly
Expense Category 24Monthly
Expense Category 29Monthly
Expense Category 30Monthly
Expense Category 32Monthly
Expense Category 33Monthly
Expense Category 34Monthly
Expense Category 37Monthly
Expense Category 38Monthly
Expense Category 43Monthly
Expense Category 44Monthly
Expense Category 45Monthly
Expense Category 39Quarterly
Expense Category 40Quarterly
Expense Category 04Semiannually
Expense Category 10Weekly
Expense Category 46Weekly

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]3[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]4[/TD]

[TD="align: right"][/TD]

[TD="align: center"]5[/TD]

[TD="align: right"]365[/TD]
[TD="align: right"][/TD]

[TD="align: right"]($50.00)[/TD]

[TD="align: right"]4/1/2019[/TD]

[TD="align: center"]6[/TD]

[TD="align: right"]52[/TD]
[TD="align: right"][/TD]

[TD="align: right"]($200.00)[/TD]

[TD="align: right"]1/1/2019[/TD]

[TD="align: center"]7[/TD]

[TD="align: right"]26[/TD]
[TD="align: right"][/TD]

[TD="align: right"]$1,000.00 [/TD]

[TD="align: right"]1/11/2019[/TD]

[TD="align: center"]8[/TD]

[TD="align: right"]12[/TD]
[TD="align: right"][/TD]

[TD="align: right"]$1,000.00 [/TD]

[TD="align: right"]1/11/2019[/TD]

[TD="align: center"]9[/TD]

[TD="align: right"]6[/TD]
[TD="align: right"][/TD]

[TD="align: right"]($1.00)[/TD]

[TD="align: right"]1/1/2019[/TD]

[TD="align: center"]10[/TD]

[TD="align: right"]4[/TD]
[TD="align: right"][/TD]

[TD="align: right"]($200.00)[/TD]

[TD="align: right"]1/1/2019[/TD]

[TD="align: center"]12[/TD]

[TD="align: right"]1[/TD]
[TD="align: right"][/TD]

[TD="align: right"]($50.00)[/TD]

[TD="align: right"]1/1/2019[/TD]

[TD="align: center"]14[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]($30.00)[/TD]

[TD="align: right"]1/12/2019[/TD]

[TD="align: center"]16[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]($100.00)[/TD]

[TD="align: right"]1/1/2019[/TD]

[TD="align: center"]20[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]($200.00)[/TD]

[TD="align: right"]1/1/2019[/TD]

[TD="align: center"]21[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]($200.00)[/TD]

[TD="align: right"]1/1/2019[/TD]

[TD="align: center"]22[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]($40.00)[/TD]

[TD="align: right"]1/17/2019[/TD]

[TD="align: center"]23[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]($1,000.00)[/TD]

[TD="align: right"]2/15/2019[/TD]

[TD="align: center"]26[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]($40.00)[/TD]

[TD="align: right"]1/22/2019[/TD]

[TD="align: center"]27[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]($70.00)[/TD]

[TD="align: right"]1/1/2019[/TD]

[TD="align: center"]28[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]($200.00)[/TD]

[TD="align: right"]1/1/2019[/TD]

[TD="align: center"]31[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]($100.00)[/TD]

[TD="align: right"]1/1/2019[/TD]

[TD="align: center"]33[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]($10.00)[/TD]

[TD="align: right"]1/1/2019[/TD]

[TD="align: center"]34[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]($10.00)[/TD]

[TD="align: right"]1/30/2019[/TD]

[TD="align: center"]36[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]($250.00)[/TD]

[TD="align: right"]1/1/2019[/TD]

[TD="align: center"]37[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]($100.00)[/TD]

[TD="align: right"]1/24/2019[/TD]

[TD="align: center"]38[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]($120.00)[/TD]

[TD="align: right"]1/24/2019[/TD]

[TD="align: center"]41[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]($130.00)[/TD]

[TD="align: right"]1/15/2019[/TD]

[TD="align: center"]42[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]($200.00)[/TD]

[TD="align: right"]1/15/2019[/TD]

[TD="align: center"]43[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]($130.00)[/TD]

[TD="align: right"]1/7/2019[/TD]

[TD="align: center"]44[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]($180.00)[/TD]

[TD="align: right"]1/10/2019[/TD]

[TD="align: center"]47[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]($50.00)[/TD]

[TD="align: right"]1/1/2019[/TD]

[TD="align: center"]48[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]($30.00)[/TD]

[TD="align: right"]2/1/2019[/TD]

[TD="align: center"]49[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]($40.00)[/TD]

[TD="align: right"]4/30/2019[/TD]

[TD="align: center"]50[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]($150.00)[/TD]

[TD="align: right"]1/1/2019[/TD]

[TD="align: center"]51[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]($40.00)[/TD]

[TD="align: right"]2/1/2019[/TD]

[TD="align: center"]52[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]($10.00)[/TD]

[TD="align: right"]1/1/2019[/TD]

[TD="align: center"]53[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

</tbody>
Budget​
 

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.
Sort by date Sort by votes
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.

[TABLE="class: grid, width: 1073"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[TD]I[/TD]
[TD]J[/TD]
[TD]K[/TD]
[TD]L[/TD]
[TD]M[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD]Type[/TD]
[TD]Value[/TD]
[TD][/TD]
[TD]Category/Description[/TD]
[TD]Budgeted Amount[/TD]
[TD]Interval[/TD]
[TD]Start Date[/TD]
[TD]n1[/TD]
[TD]n2[/TD]
[TD]n3[/TD]
[TD]n4[/TD]
[TD]n5[/TD]
[TD]n6[/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD]Daily[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD]Expense Category 06[/TD]
[TD="align: right"]($50.00)[/TD]
[TD]Annually[/TD]
[TD="align: right"]4/1/2019[/TD]
[TD="align: right"]3/31/2020[/TD]
[TD="align: right"]3/31/2021[/TD]
[TD="align: right"]3/31/2022[/TD]
[TD="align: right"]3/31/2023[/TD]
[TD="align: right"]3/30/2024[/TD]
[TD="align: right"]3/30/2025[/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD]Weekly[/TD]
[TD="align: right"]7[/TD]
[TD][/TD]
[TD]Expense Category 27[/TD]
[TD="align: right"]($200.00)[/TD]
[TD]Bimonthly[/TD]
[TD="align: right"]1/1/2019[/TD]
[TD="align: right"]3/2/2019[/TD]
[TD="align: right"]5/2/2019[/TD]
[TD="align: right"]7/2/2019[/TD]
[TD="align: right"]9/1/2019[/TD]
[TD="align: right"]11/1/2019[/TD]
[TD="align: right"]1/1/2020[/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD]BiWeekly[/TD]
[TD="align: right"]14[/TD]
[TD][/TD]
[TD]Income Category 1[/TD]
[TD="align: right"]$1,000.00[/TD]
[TD]Biweekly[/TD]
[TD="align: right"]1/11/2019[/TD]
[TD="align: right"]1/25/2019[/TD]
[TD="align: right"]2/8/2019[/TD]
[TD="align: right"]2/22/2019[/TD]
[TD="align: right"]3/8/2019[/TD]
[TD="align: right"]3/22/2019[/TD]
[TD="align: right"]4/5/2019[/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD]Monthly[/TD]
[TD="align: right"]30.41667[/TD]
[TD][/TD]
[TD]Income Category 2[/TD]
[TD="align: right"]$1,000.00[/TD]
[TD]Biweekly[/TD]
[TD="align: right"]1/11/2019[/TD]
[TD="align: right"]1/25/2019[/TD]
[TD="align: right"]2/8/2019[/TD]
[TD="align: right"]2/22/2019[/TD]
[TD="align: right"]3/8/2019[/TD]
[TD="align: right"]3/22/2019[/TD]
[TD="align: right"]4/5/2019[/TD]
[/TR]
[TR]
[TD="align: right"]6[/TD]
[TD]Bimonthly[/TD]
[TD="align: right"]60.83333[/TD]
[TD][/TD]
[TD]Expense Category 03[/TD]
[TD="align: right"]($1.00)[/TD]
[TD]Daily[/TD]
[TD="align: right"]1/1/2019[/TD]
[TD="align: right"]1/2/2019[/TD]
[TD="align: right"]1/3/2019[/TD]
[TD="align: right"]1/4/2019[/TD]
[TD="align: right"]1/5/2019[/TD]
[TD="align: right"]1/6/2019[/TD]
[TD="align: right"]1/7/2019[/TD]
[/TR]
[TR]
[TD="align: right"]7[/TD]
[TD]Quarterly[/TD]
[TD="align: right"]91.25[/TD]
[TD][/TD]
[TD]Expense Category 01[/TD]
[TD="align: right"]($200.00)[/TD]
[TD]Monthly[/TD]
[TD="align: right"]1/1/2019[/TD]
[TD="align: right"]1/31/2019[/TD]
[TD="align: right"]3/2/2019[/TD]
[TD="align: right"]4/2/2019[/TD]
[TD="align: right"]5/2/2019[/TD]
[TD="align: right"]6/2/2019[/TD]
[TD="align: right"]7/2/2019[/TD]
[/TR]
[TR]
[TD="align: right"]8[/TD]
[TD]Semiannually[/TD]
[TD="align: right"]182.5[/TD]
[TD][/TD]
[TD]Expense Category 02[/TD]
[TD="align: right"]($50.00)[/TD]
[TD]Monthly[/TD]
[TD="align: right"]1/1/2019[/TD]
[TD="align: right"]1/31/2019[/TD]
[TD="align: right"]3/2/2019[/TD]
[TD="align: right"]4/2/2019[/TD]
[TD="align: right"]5/2/2019[/TD]
[TD="align: right"]6/2/2019[/TD]
[TD="align: right"]7/2/2019[/TD]
[/TR]
[TR]
[TD="align: right"]9[/TD]
[TD]Annually[/TD]
[TD="align: right"]365[/TD]
[TD][/TD]
[TD]Expense Category 05[/TD]
[TD="align: right"]($30.00)[/TD]
[TD]Monthly[/TD]
[TD="align: right"]1/12/2019[/TD]
[TD="align: right"]2/11/2019[/TD]
[TD="align: right"]3/13/2019[/TD]
[TD="align: right"]4/13/2019[/TD]
[TD="align: right"]5/13/2019[/TD]
[TD="align: right"]6/13/2019[/TD]
[TD="align: right"]7/13/2019[/TD]
[/TR]
[TR]
[TD="align: right"]10[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Expense Category 08[/TD]
[TD="align: right"]($100.00)[/TD]
[TD]Monthly[/TD]
[TD="align: right"]1/1/2019[/TD]
[TD="align: right"]1/31/2019[/TD]
[TD="align: right"]3/2/2019[/TD]
[TD="align: right"]4/2/2019[/TD]
[TD="align: right"]5/2/2019[/TD]
[TD="align: right"]6/2/2019[/TD]
[TD="align: right"]7/2/2019[/TD]
[/TR]
[TR]
[TD="align: right"]11[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Expense Category 12[/TD]
[TD="align: right"]($200.00)[/TD]
[TD]Monthly[/TD]
[TD="align: right"]1/1/2019[/TD]
[TD="align: right"]1/31/2019[/TD]
[TD="align: right"]3/2/2019[/TD]
[TD="align: right"]4/2/2019[/TD]
[TD="align: right"]5/2/2019[/TD]
[TD="align: right"]6/2/2019[/TD]
[TD="align: right"]7/2/2019[/TD]
[/TR]
[TR]
[TD="align: right"]12[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Expense Category 16[/TD]
[TD="align: right"]($200.00)[/TD]
[TD]Monthly[/TD]
[TD="align: right"]1/1/2019[/TD]
[TD="align: right"]1/31/2019[/TD]
[TD="align: right"]3/2/2019[/TD]
[TD="align: right"]4/2/2019[/TD]
[TD="align: right"]5/2/2019[/TD]
[TD="align: right"]6/2/2019[/TD]
[TD="align: right"]7/2/2019[/TD]
[/TR]
[TR]
[TD="align: right"]13[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Expense Category 17[/TD]
[TD="align: right"]($40.00)[/TD]
[TD]Monthly[/TD]
[TD="align: right"]1/17/2019[/TD]
[TD="align: right"]2/16/2019[/TD]
[TD="align: right"]3/18/2019[/TD]
[TD="align: right"]4/18/2019[/TD]
[TD="align: right"]5/18/2019[/TD]
[TD="align: right"]6/18/2019[/TD]
[TD="align: right"]7/18/2019[/TD]
[/TR]
[TR]
[TD="align: right"]14[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Expense Category 18[/TD]
[TD="align: right"]($1,000.00)[/TD]
[TD]Monthly[/TD]
[TD="align: right"]2/15/2019[/TD]
[TD="align: right"]3/17/2019[/TD]
[TD="align: right"]4/16/2019[/TD]
[TD="align: right"]5/17/2019[/TD]
[TD="align: right"]6/16/2019[/TD]
[TD="align: right"]7/17/2019[/TD]
[TD="align: right"]8/16/2019[/TD]
[/TR]
[TR]
[TD="align: right"]15[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Expense Category 19[/TD]
[TD="align: right"]($40.00)[/TD]
[TD]Monthly[/TD]
[TD="align: right"]1/22/2019[/TD]
[TD="align: right"]2/21/2019[/TD]
[TD="align: right"]3/23/2019[/TD]
[TD="align: right"]4/23/2019[/TD]
[TD="align: right"]5/23/2019[/TD]
[TD="align: right"]6/23/2019[/TD]
[TD="align: right"]7/23/2019[/TD]
[/TR]
[TR]
[TD="align: right"]16[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Expense Category 22[/TD]
[TD="align: right"]($70.00)[/TD]
[TD]Monthly[/TD]
[TD="align: right"]1/1/2019[/TD]
[TD="align: right"]1/31/2019[/TD]
[TD="align: right"]3/2/2019[/TD]
[TD="align: right"]4/2/2019[/TD]
[TD="align: right"]5/2/2019[/TD]
[TD="align: right"]6/2/2019[/TD]
[TD="align: right"]7/2/2019[/TD]
[/TR]
[TR]
[TD="align: right"]17[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Expense Category 23[/TD]
[TD="align: right"]($200.00)[/TD]
[TD]Monthly[/TD]
[TD="align: right"]1/1/2019[/TD]
[TD="align: right"]1/31/2019[/TD]
[TD="align: right"]3/2/2019[/TD]
[TD="align: right"]4/2/2019[/TD]
[TD="align: right"]5/2/2019[/TD]
[TD="align: right"]6/2/2019[/TD]
[TD="align: right"]7/2/2019[/TD]
[/TR]
[TR]
[TD="align: right"]18[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Expense Category 24[/TD]
[TD="align: right"]($100.00)[/TD]
[TD]Monthly[/TD]
[TD="align: right"]1/1/2019[/TD]
[TD="align: right"]1/31/2019[/TD]
[TD="align: right"]3/2/2019[/TD]
[TD="align: right"]4/2/2019[/TD]
[TD="align: right"]5/2/2019[/TD]
[TD="align: right"]6/2/2019[/TD]
[TD="align: right"]7/2/2019[/TD]
[/TR]
[TR]
[TD="align: right"]19[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Expense Category 29[/TD]
[TD="align: right"]($10.00)[/TD]
[TD]Monthly[/TD]
[TD="align: right"]1/1/2019[/TD]
[TD="align: right"]1/31/2019[/TD]
[TD="align: right"]3/2/2019[/TD]
[TD="align: right"]4/2/2019[/TD]
[TD="align: right"]5/2/2019[/TD]
[TD="align: right"]6/2/2019[/TD]
[TD="align: right"]7/2/2019[/TD]
[/TR]
[TR]
[TD="align: right"]20[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Expense Category 30[/TD]
[TD="align: right"]($10.00)[/TD]
[TD]Monthly[/TD]
[TD="align: right"]1/30/2019[/TD]
[TD="align: right"]3/1/2019[/TD]
[TD="align: right"]3/31/2019[/TD]
[TD="align: right"]5/1/2019[/TD]
[TD="align: right"]5/31/2019[/TD]
[TD="align: right"]7/1/2019[/TD]
[TD="align: right"]7/31/2019[/TD]
[/TR]
[TR]
[TD="align: right"]21[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Expense Category 32[/TD]
[TD="align: right"]($250.00)[/TD]
[TD]Monthly[/TD]
[TD="align: right"]1/1/2019[/TD]
[TD="align: right"]1/31/2019[/TD]
[TD="align: right"]3/2/2019[/TD]
[TD="align: right"]4/2/2019[/TD]
[TD="align: right"]5/2/2019[/TD]
[TD="align: right"]6/2/2019[/TD]
[TD="align: right"]7/2/2019[/TD]
[/TR]
[TR]
[TD="align: right"]22[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Expense Category 33[/TD]
[TD="align: right"]($100.00)[/TD]
[TD]Monthly[/TD]
[TD="align: right"]1/24/2019[/TD]
[TD="align: right"]2/23/2019[/TD]
[TD="align: right"]3/25/2019[/TD]
[TD="align: right"]4/25/2019[/TD]
[TD="align: right"]5/25/2019[/TD]
[TD="align: right"]6/25/2019[/TD]
[TD="align: right"]7/25/2019[/TD]
[/TR]
[TR]
[TD="align: right"]23[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Expense Category 34[/TD]
[TD="align: right"]($120.00)[/TD]
[TD]Monthly[/TD]
[TD="align: right"]1/24/2019[/TD]
[TD="align: right"]2/23/2019[/TD]
[TD="align: right"]3/25/2019[/TD]
[TD="align: right"]4/25/2019[/TD]
[TD="align: right"]5/25/2019[/TD]
[TD="align: right"]6/25/2019[/TD]
[TD="align: right"]7/25/2019[/TD]
[/TR]
[TR]
[TD="align: right"]24[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Expense Category 37[/TD]
[TD="align: right"]($130.00)[/TD]
[TD]Monthly[/TD]
[TD="align: right"]1/15/2019[/TD]
[TD="align: right"]2/14/2019[/TD]
[TD="align: right"]3/16/2019[/TD]
[TD="align: right"]4/16/2019[/TD]
[TD="align: right"]5/16/2019[/TD]
[TD="align: right"]6/16/2019[/TD]
[TD="align: right"]7/16/2019[/TD]
[/TR]
[TR]
[TD="align: right"]25[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Expense Category 38[/TD]
[TD="align: right"]($200.00)[/TD]
[TD]Monthly[/TD]
[TD="align: right"]1/15/2019[/TD]
[TD="align: right"]2/14/2019[/TD]
[TD="align: right"]3/16/2019[/TD]
[TD="align: right"]4/16/2019[/TD]
[TD="align: right"]5/16/2019[/TD]
[TD="align: right"]6/16/2019[/TD]
[TD="align: right"]7/16/2019[/TD]
[/TR]
[TR]
[TD="align: right"]26[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Expense Category 43[/TD]
[TD="align: right"]($130.00)[/TD]
[TD]Monthly[/TD]
[TD="align: right"]1/7/2019[/TD]
[TD="align: right"]2/6/2019[/TD]
[TD="align: right"]3/8/2019[/TD]
[TD="align: right"]4/8/2019[/TD]
[TD="align: right"]5/8/2019[/TD]
[TD="align: right"]6/8/2019[/TD]
[TD="align: right"]7/8/2019[/TD]
[/TR]
[TR]
[TD="align: right"]27[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Expense Category 44[/TD]
[TD="align: right"]($180.00)[/TD]
[TD]Monthly[/TD]
[TD="align: right"]1/10/2019[/TD]
[TD="align: right"]2/9/2019[/TD]
[TD="align: right"]3/11/2019[/TD]
[TD="align: right"]4/11/2019[/TD]
[TD="align: right"]5/11/2019[/TD]
[TD="align: right"]6/11/2019[/TD]
[TD="align: right"]7/11/2019[/TD]
[/TR]
[TR]
[TD="align: right"]28[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Expense Category 45[/TD]
[TD="align: right"]($50.00)[/TD]
[TD]Monthly[/TD]
[TD="align: right"]1/1/2019[/TD]
[TD="align: right"]1/31/2019[/TD]
[TD="align: right"]3/2/2019[/TD]
[TD="align: right"]4/2/2019[/TD]
[TD="align: right"]5/2/2019[/TD]
[TD="align: right"]6/2/2019[/TD]
[TD="align: right"]7/2/2019[/TD]
[/TR]
[TR]
[TD="align: right"]29[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Expense Category 39[/TD]
[TD="align: right"]($30.00)[/TD]
[TD]Quarterly[/TD]
[TD="align: right"]2/1/2019[/TD]
[TD="align: right"]5/3/2019[/TD]
[TD="align: right"]8/2/2019[/TD]
[TD="align: right"]11/1/2019[/TD]
[TD="align: right"]2/1/2020[/TD]
[TD="align: right"]5/2/2020[/TD]
[TD="align: right"]8/1/2020[/TD]
[/TR]
[TR]
[TD="align: right"]30[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Expense Category 40[/TD]
[TD="align: right"]($40.00)[/TD]
[TD]Quarterly[/TD]
[TD="align: right"]4/30/2019[/TD]
[TD="align: right"]7/30/2019[/TD]
[TD="align: right"]10/29/2019[/TD]
[TD="align: right"]1/28/2020[/TD]
[TD="align: right"]4/29/2020[/TD]
[TD="align: right"]7/29/2020[/TD]
[TD="align: right"]10/28/2020[/TD]
[/TR]
[TR]
[TD="align: right"]31[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Expense Category 04[/TD]
[TD="align: right"]($150.00)[/TD]
[TD]Semiannually[/TD]
[TD="align: right"]1/1/2019[/TD]
[TD="align: right"]7/2/2019[/TD]
[TD="align: right"]1/1/2020[/TD]
[TD="align: right"]7/1/2020[/TD]
[TD="align: right"]12/31/2020[/TD]
[TD="align: right"]7/1/2021[/TD]
[TD="align: right"]12/31/2021[/TD]
[/TR]
[TR]
[TD="align: right"]32[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Expense Category 10[/TD]
[TD="align: right"]($40.00)[/TD]
[TD]Weekly[/TD]
[TD="align: right"]2/1/2019[/TD]
[TD="align: right"]2/8/2019[/TD]
[TD="align: right"]2/15/2019[/TD]
[TD="align: right"]2/22/2019[/TD]
[TD="align: right"]3/1/2019[/TD]
[TD="align: right"]3/8/2019[/TD]
[TD="align: right"]3/15/2019[/TD]
[/TR]
[TR]
[TD="align: right"]33[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Expense Category 46[/TD]
[TD="align: right"]($10.00)[/TD]
[TD]Weekly[/TD]
[TD="align: right"]1/1/2019[/TD]
[TD="align: right"]1/8/2019[/TD]
[TD="align: right"]1/15/2019[/TD]
[TD="align: right"]1/22/2019[/TD]
[TD="align: right"]1/29/2019[/TD]
[TD="align: right"]2/5/2019[/TD]
[TD="align: right"]2/12/2019[/TD]
[/TR]
</tbody>[/TABLE]
 
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
FrequencyTableUserBudgetTableNext Occurrence based on todays date
RecurrenceOccurrences Per YearCategory/DescriptionBudgeted AmountIntervalAssociated/Start Daten1n2n3n4n5n6
DailyExpense Category 06Annually
WeeklyExpense Category 27Bimonthly
BiweeklyIncome Category 1Biweekly
MonthlyIncome Category 2Biweekly
BimonthlyExpense Category 03Daily
QuarterlyExpense Category 01Monthly
SemiannuallyExpense Category 02Monthly
AnnuallyExpense Category 05Monthly
Expense Category 08Monthly
Expense Category 12Monthly
Expense Category 16Monthly
Expense Category 17Monthly
Expense Category 18Monthly
Expense Category 19Monthly
Expense Category 22Monthly
Expense Category 23Monthly
Expense Category 24Monthly
Expense Category 29Monthly
Expense Category 30Monthly
Expense Category 32Monthly
Expense Category 33Monthly
Expense Category 34Monthly
Expense Category 37Monthly
Expense Category 38Monthly
Expense Category 43Monthly
Expense Category 44Monthly
Expense Category 45Monthly
Expense Category 39Quarterly
Expense Category 40Quarterly
Expense Category 04Semiannually
Expense Category 10Weekly
Expense Category 46Weekly

<tbody>
[TD="align: center"]3[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]4[/TD]

[TD="align: right"][/TD]

[TD="align: center"]5[/TD]

[TD="align: right"]365[/TD]
[TD="align: right"][/TD]

[TD="align: right"]($50.00)[/TD]

[TD="align: right"]4/1/2019[/TD]
[TD="align: right"]4/1/2020[/TD]
[TD="align: right"]4/1/2021[/TD]
[TD="align: right"]4/1/2022[/TD]
[TD="align: right"]4/1/2023[/TD]
[TD="align: right"]4/1/2024[/TD]
[TD="align: right"]4/1/2025[/TD]

[TD="align: center"]6[/TD]

[TD="align: right"]52[/TD]
[TD="align: right"][/TD]

[TD="align: right"]($200.00)[/TD]

[TD="align: right"]1/1/2019[/TD]
[TD="align: right"]3/1/2019[/TD]
[TD="align: right"]5/1/2019[/TD]
[TD="align: right"]7/1/2019[/TD]
[TD="align: right"]9/1/2019[/TD]
[TD="align: right"]11/1/2019[/TD]
[TD="align: right"]1/1/2020[/TD]

[TD="align: center"]7[/TD]

[TD="align: right"]26[/TD]
[TD="align: right"][/TD]

[TD="align: right"]$1,000.00[/TD]

[TD="align: right"]1/4/2019[/TD]
[TD="align: right"]3/1/2019[/TD]
[TD="align: right"]3/15/2019[/TD]
[TD="align: right"]3/29/2019[/TD]
[TD="align: right"]4/12/2019[/TD]
[TD="align: right"]4/26/2019[/TD]
[TD="align: right"]5/10/2019[/TD]

[TD="align: center"]8[/TD]

[TD="align: right"]12[/TD]
[TD="align: right"][/TD]

[TD="align: right"]$1,000.00[/TD]

[TD="align: right"]1/11/2019[/TD]
[TD="align: right"]3/8/2019[/TD]
[TD="align: right"]3/22/2019[/TD]
[TD="align: right"]4/5/2019[/TD]
[TD="align: right"]4/19/2019[/TD]
[TD="align: right"]5/3/2019[/TD]
[TD="align: right"]5/17/2019[/TD]

[TD="align: center"]9[/TD]

[TD="align: right"]6[/TD]
[TD="align: right"][/TD]

[TD="align: right"]($1.00)[/TD]

[TD="align: right"]1/1/2019[/TD]
[TD="align: right"]2/26/2019[/TD]
[TD="align: right"]2/27/2019[/TD]
[TD="align: right"]2/28/2019[/TD]
[TD="align: right"]3/1/2019[/TD]
[TD="align: right"]3/2/2019[/TD]
[TD="align: right"]3/3/2019[/TD]

[TD="align: center"]10[/TD]

[TD="align: right"]4[/TD]
[TD="align: right"][/TD]

[TD="align: right"]($200.00)[/TD]

[TD="align: right"]1/1/2019[/TD]
[TD="align: right"]3/1/2019[/TD]
[TD="align: right"]4/1/2019[/TD]
[TD="align: right"]5/1/2019[/TD]
[TD="align: right"]6/1/2019[/TD]
[TD="align: right"]7/1/2019[/TD]
[TD="align: right"]8/1/2019[/TD]

[TD="align: center"]11[/TD]

[TD="align: right"]2[/TD]
[TD="align: right"][/TD]

[TD="align: right"]($50.00)[/TD]

[TD="align: right"]1/1/2019[/TD]
[TD="align: right"]3/1/2019[/TD]
[TD="align: right"]4/1/2019[/TD]
[TD="align: right"]5/1/2019[/TD]
[TD="align: right"]6/1/2019[/TD]
[TD="align: right"]7/1/2019[/TD]
[TD="align: right"]8/1/2019[/TD]

[TD="align: center"]12[/TD]

[TD="align: right"]1[/TD]
[TD="align: right"][/TD]

[TD="align: right"]($30.00)[/TD]

[TD="align: right"]1/12/2019[/TD]
[TD="align: right"]3/12/2019[/TD]
[TD="align: right"]4/12/2019[/TD]
[TD="align: right"]5/12/2019[/TD]
[TD="align: right"]6/12/2019[/TD]
[TD="align: right"]7/12/2019[/TD]
[TD="align: right"]8/12/2019[/TD]

[TD="align: center"]13[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]($100.00)[/TD]

[TD="align: right"]1/1/2019[/TD]
[TD="align: right"]3/1/2019[/TD]
[TD="align: right"]4/1/2019[/TD]
[TD="align: right"]5/1/2019[/TD]
[TD="align: right"]6/1/2019[/TD]
[TD="align: right"]7/1/2019[/TD]
[TD="align: right"]8/1/2019[/TD]

[TD="align: center"]14[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]($200.00)[/TD]

[TD="align: right"]1/1/2019[/TD]
[TD="align: right"]3/1/2019[/TD]
[TD="align: right"]4/1/2019[/TD]
[TD="align: right"]5/1/2019[/TD]
[TD="align: right"]6/1/2019[/TD]
[TD="align: right"]7/1/2019[/TD]
[TD="align: right"]8/1/2019[/TD]

[TD="align: center"]15[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]($200.00)[/TD]

[TD="align: right"]1/1/2019[/TD]
[TD="align: right"]3/1/2019[/TD]
[TD="align: right"]4/1/2019[/TD]
[TD="align: right"]5/1/2019[/TD]
[TD="align: right"]6/1/2019[/TD]
[TD="align: right"]7/1/2019[/TD]
[TD="align: right"]8/1/2019[/TD]

[TD="align: center"]16[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]($40.00)[/TD]

[TD="align: right"]1/17/2019[/TD]
[TD="align: right"]3/17/2019[/TD]
[TD="align: right"]4/17/2019[/TD]
[TD="align: right"]5/17/2019[/TD]
[TD="align: right"]6/17/2019[/TD]
[TD="align: right"]7/17/2019[/TD]
[TD="align: right"]8/17/2019[/TD]

[TD="align: center"]17[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]($1,000.00)[/TD]

[TD="align: right"]2/15/2019[/TD]
[TD="align: right"]3/15/2019[/TD]
[TD="align: right"]4/15/2019[/TD]
[TD="align: right"]5/15/2019[/TD]
[TD="align: right"]6/15/2019[/TD]
[TD="align: right"]7/15/2019[/TD]
[TD="align: right"]8/15/2019[/TD]

[TD="align: center"]18[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]($40.00)[/TD]

[TD="align: right"]1/22/2019[/TD]
[TD="align: right"]3/22/2019[/TD]
[TD="align: right"]4/22/2019[/TD]
[TD="align: right"]5/22/2019[/TD]
[TD="align: right"]6/22/2019[/TD]
[TD="align: right"]7/22/2019[/TD]
[TD="align: right"]8/22/2019[/TD]

[TD="align: center"]19[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]($70.00)[/TD]

[TD="align: right"]1/1/2019[/TD]
[TD="align: right"]3/1/2019[/TD]
[TD="align: right"]4/1/2019[/TD]
[TD="align: right"]5/1/2019[/TD]
[TD="align: right"]6/1/2019[/TD]
[TD="align: right"]7/1/2019[/TD]
[TD="align: right"]8/1/2019[/TD]

[TD="align: center"]20[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]($200.00)[/TD]

[TD="align: right"]1/1/2019[/TD]
[TD="align: right"]3/1/2019[/TD]
[TD="align: right"]4/1/2019[/TD]
[TD="align: right"]5/1/2019[/TD]
[TD="align: right"]6/1/2019[/TD]
[TD="align: right"]7/1/2019[/TD]
[TD="align: right"]8/1/2019[/TD]

[TD="align: center"]21[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]($100.00)[/TD]

[TD="align: right"]1/1/2019[/TD]
[TD="align: right"]3/1/2019[/TD]
[TD="align: right"]4/1/2019[/TD]
[TD="align: right"]5/1/2019[/TD]
[TD="align: right"]6/1/2019[/TD]
[TD="align: right"]7/1/2019[/TD]
[TD="align: right"]8/1/2019[/TD]

[TD="align: center"]22[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]($10.00)[/TD]

[TD="align: right"]1/1/2019[/TD]
[TD="align: right"]3/1/2019[/TD]
[TD="align: right"]4/1/2019[/TD]
[TD="align: right"]5/1/2019[/TD]
[TD="align: right"]6/1/2019[/TD]
[TD="align: right"]7/1/2019[/TD]
[TD="align: right"]8/1/2019[/TD]

[TD="align: center"]23[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]($10.00)[/TD]

[TD="align: right"]1/30/2019[/TD]
[TD="align: right"]3/2/2019[/TD]
[TD="align: right"]3/2/2019[/TD]
[TD="align: right"]3/2/2019[/TD]
[TD="align: right"]3/2/2019[/TD]
[TD="align: right"]3/2/2019[/TD]
[TD="align: right"]3/2/2019[/TD]

[TD="align: center"]24[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]($250.00)[/TD]

[TD="align: right"]1/1/2019[/TD]
[TD="align: right"]3/1/2019[/TD]
[TD="align: right"]4/1/2019[/TD]
[TD="align: right"]5/1/2019[/TD]
[TD="align: right"]6/1/2019[/TD]
[TD="align: right"]7/1/2019[/TD]
[TD="align: right"]8/1/2019[/TD]

[TD="align: center"]25[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]($100.00)[/TD]

[TD="align: right"]1/24/2019[/TD]
[TD="align: right"]3/24/2019[/TD]
[TD="align: right"]4/24/2019[/TD]
[TD="align: right"]5/24/2019[/TD]
[TD="align: right"]6/24/2019[/TD]
[TD="align: right"]7/24/2019[/TD]
[TD="align: right"]8/24/2019[/TD]

[TD="align: center"]26[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]($120.00)[/TD]

[TD="align: right"]1/24/2019[/TD]
[TD="align: right"]3/24/2019[/TD]
[TD="align: right"]4/24/2019[/TD]
[TD="align: right"]5/24/2019[/TD]
[TD="align: right"]6/24/2019[/TD]
[TD="align: right"]7/24/2019[/TD]
[TD="align: right"]8/24/2019[/TD]

[TD="align: center"]27[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]($130.00)[/TD]

[TD="align: right"]1/15/2019[/TD]
[TD="align: right"]3/15/2019[/TD]
[TD="align: right"]4/15/2019[/TD]
[TD="align: right"]5/15/2019[/TD]
[TD="align: right"]6/15/2019[/TD]
[TD="align: right"]7/15/2019[/TD]
[TD="align: right"]8/15/2019[/TD]

[TD="align: center"]28[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]($200.00)[/TD]

[TD="align: right"]1/15/2019[/TD]
[TD="align: right"]3/15/2019[/TD]
[TD="align: right"]4/15/2019[/TD]
[TD="align: right"]5/15/2019[/TD]
[TD="align: right"]6/15/2019[/TD]
[TD="align: right"]7/15/2019[/TD]
[TD="align: right"]8/15/2019[/TD]

[TD="align: center"]29[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]($130.00)[/TD]

[TD="align: right"]1/7/2019[/TD]
[TD="align: right"]3/7/2019[/TD]
[TD="align: right"]4/7/2019[/TD]
[TD="align: right"]5/7/2019[/TD]
[TD="align: right"]6/7/2019[/TD]
[TD="align: right"]7/7/2019[/TD]
[TD="align: right"]8/7/2019[/TD]

[TD="align: center"]30[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]($180.00)[/TD]

[TD="align: right"]1/10/2019[/TD]
[TD="align: right"]3/10/2019[/TD]
[TD="align: right"]4/10/2019[/TD]
[TD="align: right"]5/10/2019[/TD]
[TD="align: right"]6/10/2019[/TD]
[TD="align: right"]7/10/2019[/TD]
[TD="align: right"]8/10/2019[/TD]

[TD="align: center"]31[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]($50.00)[/TD]

[TD="align: right"]1/1/2019[/TD]
[TD="align: right"]3/1/2019[/TD]
[TD="align: right"]4/1/2019[/TD]
[TD="align: right"]5/1/2019[/TD]
[TD="align: right"]6/1/2019[/TD]
[TD="align: right"]7/1/2019[/TD]
[TD="align: right"]8/1/2019[/TD]

[TD="align: center"]32[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]($30.00)[/TD]

[TD="align: right"]2/1/2019[/TD]
[TD="align: right"]5/1/2019[/TD]
[TD="align: right"]8/1/2019[/TD]
[TD="align: right"]11/1/2019[/TD]
[TD="align: right"]2/1/2020[/TD]
[TD="align: right"]5/1/2020[/TD]
[TD="align: right"]8/1/2020[/TD]

[TD="align: center"]33[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]($40.00)[/TD]

[TD="align: right"]4/30/2019[/TD]
[TD="align: right"]7/30/2019[/TD]
[TD="align: right"]10/30/2019[/TD]
[TD="align: right"]1/30/2020[/TD]
[TD="align: right"]4/30/2020[/TD]
[TD="align: right"]7/30/2020[/TD]
[TD="align: right"]10/30/2020[/TD]

[TD="align: center"]34[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]($150.00)[/TD]

[TD="align: right"]1/1/2019[/TD]
[TD="align: right"]7/1/2019[/TD]
[TD="align: right"]1/1/2020[/TD]
[TD="align: right"]7/1/2020[/TD]
[TD="align: right"]1/1/2021[/TD]
[TD="align: right"]7/1/2021[/TD]
[TD="align: right"]1/1/2022[/TD]

[TD="align: center"]35[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]($40.00)[/TD]

[TD="align: right"]2/1/2019[/TD]
[TD="align: right"]3/1/2019[/TD]
[TD="align: right"]3/8/2019[/TD]
[TD="align: right"]3/15/2019[/TD]
[TD="align: right"]3/22/2019[/TD]
[TD="align: right"]3/29/2019[/TD]
[TD="align: right"]4/5/2019[/TD]

[TD="align: center"]36[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]($10.00)[/TD]

[TD="align: right"]1/1/2019[/TD]
[TD="align: right"]2/26/2019[/TD]
[TD="align: right"]3/5/2019[/TD]
[TD="align: right"]3/12/2019[/TD]
[TD="align: right"]3/19/2019[/TD]
[TD="align: right"]3/26/2019[/TD]
[TD="align: right"]4/2/2019[/TD]

</tbody>
Budget​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<tbody>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TH]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]I5[/TH]
[TD="align: left"]=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))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]J5[/TH]
[TD="align: left"]=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))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]K5[/TH]
[TD="align: left"]=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))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]L5[/TH]
[TD="align: left"]=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))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]M5[/TH]
[TD="align: left"]=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))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]N5[/TH]
[TD="align: left"]=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))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]I6[/TH]
[TD="align: left"]=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))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]J6[/TH]
[TD="align: left"]=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))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]K6[/TH]
[TD="align: left"]=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))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]L6[/TH]
[TD="align: left"]=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))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]M6[/TH]
[TD="align: left"]=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))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]N6[/TH]
[TD="align: left"]=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))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]I7[/TH]
[TD="align: left"]=MOD(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]-TODAY(),14)+TODAY()+(14*((COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))-1))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]J7[/TH]
[TD="align: left"]=MOD(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]-TODAY(),14)+TODAY()+(14*((COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))-1))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]K7[/TH]
[TD="align: left"]=MOD(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]-TODAY(),14)+TODAY()+(14*((COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))-1))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]L7[/TH]
[TD="align: left"]=MOD(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]-TODAY(),14)+TODAY()+(14*((COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))-1))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]M7[/TH]
[TD="align: left"]=MOD(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]-TODAY(),14)+TODAY()+(14*((COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))-1))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]N7[/TH]
[TD="align: left"]=MOD(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]-TODAY(),14)+TODAY()+(14*((COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))-1))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]I8[/TH]
[TD="align: left"]=MOD(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]-TODAY(),14)+TODAY()+(14*((COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))-1))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]J8[/TH]
[TD="align: left"]=MOD(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]-TODAY(),14)+TODAY()+(14*((COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))-1))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]K8[/TH]
[TD="align: left"]=MOD(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]-TODAY(),14)+TODAY()+(14*((COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))-1))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]L8[/TH]
[TD="align: left"]=MOD(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]-TODAY(),14)+TODAY()+(14*((COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))-1))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]M8[/TH]
[TD="align: left"]=MOD(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]-TODAY(),14)+TODAY()+(14*((COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))-1))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]N8[/TH]
[TD="align: left"]=MOD(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]-TODAY(),14)+TODAY()+(14*((COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]]))-1))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]I9[/TH]
[TD="align: left"]=(TODAY()+(COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]])))-1[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]J9[/TH]
[TD="align: left"]=(TODAY()+(COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]])))-1[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]K9[/TH]
[TD="align: left"]=(TODAY()+(COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]])))-1[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]L9[/TH]
[TD="align: left"]=(TODAY()+(COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]])))-1[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]M9[/TH]
[TD="align: left"]=(TODAY()+(COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]])))-1[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]N9[/TH]
[TD="align: left"]=(TODAY()+(COLUMN()-COLUMN(UserBudgetTable[@[Associated/Start Date]:[Associated/Start Date]])))-1[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]I10[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]J10[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]K10[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]L10[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]M10[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]N10[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]I11[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]J11[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]K11[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]L11[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]M11[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]N11[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]I12[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]J12[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]K12[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]L12[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]M12[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]N12[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]I13[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]J13[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]K13[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]L13[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]M13[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]N13[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]I14[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]J14[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]K14[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]L14[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]M14[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]N14[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]I15[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]J15[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]K15[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]L15[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]M15[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]N15[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]I16[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]J16[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]K16[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]L16[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]M16[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]N16[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]I17[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]J17[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]K17[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]L17[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]M17[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]N17[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]I18[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]J18[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]K18[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]L18[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]M18[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]N18[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]I19[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]J19[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]K19[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]L19[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]M19[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]N19[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]I20[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]J20[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]K20[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]L20[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]M20[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]N20[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]I21[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]J21[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]K21[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]L21[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]M21[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]N21[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]I22[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]J22[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]K22[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]L22[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]M22[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]N22[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]I23[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]J23[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]K23[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]L23[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]M23[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]N23[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]I24[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]J24[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]K24[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]L24[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]M24[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]N24[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]I25[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]J25[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]K25[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]L25[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]M25[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]N25[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]I26[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]J26[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]K26[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]L26[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]M26[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]N26[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]I27[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]J27[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]K27[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]L27[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]M27[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]N27[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]I28[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]J28[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]K28[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]L28[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]M28[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]N28[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]I29[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]J29[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]K29[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]L29[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]M29[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]N29[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]I30[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]J30[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]K30[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]L30[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]M30[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]N30[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]I31[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]J31[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]K31[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]L31[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]M31[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]N31[/TH]
[TD="align: left"]=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]]))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]I32[/TH]
[TD="align: left"]=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))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]J32[/TH]
[TD="align: left"]=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))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]K32[/TH]
[TD="align: left"]=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))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]L32[/TH]
[TD="align: left"]=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))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]M32[/TH]
[TD="align: left"]=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))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]N32[/TH]
[TD="align: left"]=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))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]I33[/TH]
[TD="align: left"]=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))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]J33[/TH]
[TD="align: left"]=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))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]K33[/TH]
[TD="align: left"]=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))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]L33[/TH]
[TD="align: left"]=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))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]M33[/TH]
[TD="align: left"]=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))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]N33[/TH]
[TD="align: left"]=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))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]I34[/TH]
[TD="align: left"]=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))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]J34[/TH]
[TD="align: left"]=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))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]K34[/TH]
[TD="align: left"]=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))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]L34[/TH]
[TD="align: left"]=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))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]M34[/TH]
[TD="align: left"]=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))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]N34[/TH]
[TD="align: left"]=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))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]I35[/TH]
[TD="align: left"]=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)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]J35[/TH]
[TD="align: left"]=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)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]K35[/TH]
[TD="align: left"]=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)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]L35[/TH]
[TD="align: left"]=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)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]M35[/TH]
[TD="align: left"]=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)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]N35[/TH]
[TD="align: left"]=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)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]I36[/TH]
[TD="align: left"]=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)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]J36[/TH]
[TD="align: left"]=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)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]K36[/TH]
[TD="align: left"]=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)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]L36[/TH]
[TD="align: left"]=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)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]M36[/TH]
[TD="align: left"]=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)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]N36[/TH]
[TD="align: left"]=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)[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]



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
You must log in or register to reply here.

Similar threads

MrDB4Excel
  • Question Question
Lookup Amount Varies For Specific Category
Replies
4
Views
558
Alex Blakenburg
A
A
  • Solved
Track movement stock in listbox on userform by copy amounts from previous row to next row
Replies
8
Views
93
abdo meghari
A
W
  • Solved
Fiscal Quarter Percentage difference
2 3
Replies
22
Views
1K
Walker_Ice
W
K
  • Question Question
exclude TOTAL row and sum TOTAL column based on sheet name
Replies
0
Views
371
KalilMe
K
A
  • Question Question
create report for 40000 rows to calculation stock across sheet based on sheet name in cell value
Replies
1
Views
349
Amer Omar
A

Forum statistics

Threads
1,223,893
Messages
6,175,240
Members
452,621
Latest member
Laura_PinksBTHFT

Share this page

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