Forum Discussion

Elisa112's avatar
Elisa112
Icon for Helper V rankHelper V
2 years ago
Solved

Calculate a future date from a date column

Hi Experts I am trying to calculate a future date (3 months) from the last appointment date for our users.  This will allow us to cancel membership 3 months from the last appointment.  My summary ta...
Need Help
  • v-weiyan1-msft's avatar
    v-weiyan1-msft
    2 years ago

    Hi Elisa112 ,

     

    amitchandak nice method! Thank you, for your quick response and the solution provided.
    And based on the sample and description you provided, you can also try code as below to create a Calculated column.

    FutureDate = 
EDATE ( 'Table'[Last appointment date], 3 )

    Result is as below.


    Best Regards,
    Yulia Yan


    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-weiyan1-msft's avatar
v-weiyan1-msft
Icon for Community Support rankCommunity Support
2 years ago

Hi Elisa112 ,

 

amitchandak nice method! Thank you, for your quick response and the solution provided.
And based on the sample and description you provided, you can also try code as below to create a Calculated column.

FutureDate = 
EDATE ( 'Table'[Last appointment date], 3 )

Result is as below.


Best Regards,
Yulia Yan


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.