Date Difference

[WJ876400]

Hi

I want to find the difference between a past date and todays date, which I have done with this formula 

DATEDIFF([REVIEW],TODAY(),MONTH)

How  ever as you can see below there are some ID's that have a return date and I want to do the months between off that date instead of the review.

ID	Review	Return Date	Months Between
1	01/10/2021
2	06/05/2021	05/03/2022
3	24/03/2022
4	17/06/2022
5	01/05/2021	12/12/2021

So I want to do months between the review date and today if the return date is blank. If it is not blank do the months between the return date and today.

Hope that makes sense any help is appreciated

thanks

[WJ876400]

@PC2790 thank you very much it worked!

[PC2790 · Accepted solution]

Hey @WJ876400 ,

Here, try this:

MonthBetweenColumn = 
if('Table'[Return Date] <> BLANK(),DATEDIFF('Table'[Return Date],TODAY(),MONTH),DATEDIFF('Table'[Review],TODAY(),MONTH))

Are you looking for this?