Get instant live expert help on convert 3 months

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

I need to recreate this formula in other cells =(GETPIVOTDATA("Sum of Revenue",$A$3,"Months",2)-GETPIVOTDATA("Sum of Revenue",$A$3,"Months",1))/GETPIVOTDATA("Sum of Revenue",$A$3,"Months",1)
Solved by D. J. in 18 mins
Can you convert actual days of the work for the years to months or weeks
Solved by D. F. in 14 mins
I tried to convert a value into date but excel gave me a unique string referencing months and years instead.
Solved by V. B. in 19 mins
trying to find out average for all staff less then 3 months, 3-12 months and 12months and above for calls, emails, outbound and welcome call
Solved by V. U. in 16 mins
I want a conditional format of 3 colours. If the date is 3 months from expiring - Green If the date is within 3 months - Orange or expired - Red; I have this but I don't think it is working as nothing is 'green...' =IF(T4<0,"Expired",IF(T4<90,"Expires Soon",IF(T4<91,"Expires in 3 months","")))
Solved by I. H. in 28 mins