T
tomttom40
Can anyone advise on te following:
Where:
Date A is input date
Month 1 (Jan) = x
Month 2 (Feb) = y
Month 3 (March) = z
& so on
Require formula to calculate as follows:
If date A = Jan then calculate x
If date A = Feb then calculate x+y
If date A = March then calculate x+y+z
and so on, required for a 24 month period
TTT
Where:
Date A is input date
Month 1 (Jan) = x
Month 2 (Feb) = y
Month 3 (March) = z
& so on
Require formula to calculate as follows:
If date A = Jan then calculate x
If date A = Feb then calculate x+y
If date A = March then calculate x+y+z
and so on, required for a 24 month period
TTT