Number of months per year between 2 dates

nbaudry
Posts: 2
Joined: Thu Aug 15, 2019 10:02 pm

Number of months per year between 2 dates

Postby nbaudry » Thu Aug 15, 2019 10:08 pm

Hello,

I would like to calcultate the number of months per year between 2 dates.
My table is like this:
ID---------------Year---------------Start date--------End date-----------------Result(my wish)
150-------------2018--------------18/08/2018-------30/06/2020--------------5
150-------------2019--------------18/08/2018-------30/06/2020--------------12
150-------------2020--------------18/08/2018-------30/06/2020--------------6

Thanks a lot for your help
N.

Return to “Power Query”

Who is online

Users browsing this forum: No registered users and 3 guests