Date Calculation

[chiragpatel_1]

In the attached file,  the 'months into scheme column' is calculated using the below formula which works but the dilemma is that when the 'date to' is in future from now, the calculation works fine but when 'date to' is in the past, it falls over. 'Expected output should be' column is what I'm expecting the calculation should be, second row is perfect example where the issue is.

what do i add to the below formula to fix that issue?

[TheOC · Accepted solution]

hi @chiragpatel_1 

I believe i have fixed your problem. I changed your formula to an if statement - stating that if the 'date to' date is before today, use that date as the comparison, otherwise use todays date:

I've attached the workflow, my formula is as 'months date2'.

Hope this helps,
TheOC

[mattnason1]

I did 3 formulas and it seems to work:

[atcodedog05]

Glad to hear this got resolved 🙂 sorry I couldn't help you out with the recent request link  @chiragpatel_1 

Kudos to @TheOC on solving this 😀👍

[chiragpatel_1]

Thank you, for quick reply @TheOC 

@atcodedog05 no worries, with your original formula you got me half way there though.

[TheOC]

no problem @chiragpatel_1 ! Happy to help!

Cheers for the Kudos @atcodedog05 😀👍🏻