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