Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Month difference calculation

Hi,

 

  Please help me  to solve below logic.

 

if date1(Month) column greater than Date2(month) column  and having month difference as 2 month then return "2 month difference"

if date1(Month) column greater than Date2(month) column  and having month difference as 3 month then return "3 month difference"

 

Date1                  Date2                  Expected Calculated column

 

12/30/2019        10/25/2019             2 month difference   

12/30/2019        11/25/2019              1 month difference

12/30/2019         9/25/2019               3 month differnce 

 

 

Regards

Privya

 

 

 

2 Replies