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","")))