2 Replies Latest reply on Nov 25, 2013 12:58 PM by IlseVerhaert

# Calculate months of project participation within this year

### Title

Calculate months of project participation within this year

### Post

I know how to calculate the months that a client is participating in our project (since the moment he signed up till the current date). Now I am wondering what the formula is to calculate the months that the client is participating only in this year. So, if a client is participating since September 2013, the field 'MonthsParticipatingThisYear' should only display '11' and not '15' (adding up all months since start). I don't know if I am making myself clear on this point?

Thank you so much,

Ilse

• ###### 1. Re: Calculate months of project participation within this year

It has to be September 2012.

Let([
ds = the date he signed up ;
f = Date ( 1 ; 1 ; Year ( Get ( CurrentDate ) ) ) ;
d = If ( ds <  f ; f ; ds )
];
Month ( Get ( CurrentDate ) ) - Month ( d ) + 1
)
• ###### 2. Re: Calculate months of project participation within this year

Works great, thank you so much!!