Time to close by months

[Anonymous]

Hi All,

I have a script for Time to close an opportunity by days.

if(ceil(([Close Date]-[Created Date]),30)>0,ceil(([Close Date]-[Created Date]),30),'entered after close date')

I would like to show this by months. Can you help me changing the script?

[cazztfplease]

I would use your existing expression to define 'Days to close' as a variable.  Then you use the newly defined variable to define another variable, vMonthstoClose where it equals $(vDaystoClose)/30.

[pradosh_thakur]

can you be a little bit clear on your reuirement?