PDIFF , DDIFF
 

What do these mean and how do they work?

Thank you,

Steven

Answer: PDIFF , DDIFF
 

Hi Steven,

PDIFF and DDIFF are two functions in Microsoft Excel that are used to calculate the difference between two values. Here's a breakdown of what each function does:

1. PDIFF: This function calculates the percentage difference between two values. The formula for PDIFF is:
   
   
   Formula:

   ---

   PDIFF = ((New Value - Old Value) / Old Value) * 100 


   ---

   For example, if you want to calculate the percentage difference between the values 50 and 75, you would use the formula:
   
   
   Formula:

   ---

   PDIFF = ((75 - 50) / 50) * 100 = 50% 


   ---

   This means that the new value (75) is 50% higher than the old value (50).
   
2. DDIFF: This function calculates the difference between two dates in days. The formula for DDIFF is:
   
   
   Formula:

   ---

   DDIFF = End Date - Start Date 


   ---

   For example, if you want to calculate the number of days between January 1, 2021 and January 15, 2021, you would use the formula:
   
   
   Formula:

   ---

   DDIFF = 1/15/2021 - 1/1/2021 = 14 


   ---

   This means that there are 14 days between the two dates.

PDIFF , DDIFF
 

Steven -

If these are functions, it might mean that you have an add-in installed.

- Mike


"Steven" wrote in message
...
What do these mean and how do they work?

Thank you,

Steven