MicrosoftExcel 'Finding Date Difference for PivotChart Data' Work-Through

Question

Hello,
I am using Microsoft Excel to create a document where we track errors. I have a date they're found and date they're corrected. I wanted to find the difference between the two columns and using a pivot chart to keep track of how long an error is open'.

I used the above formula in the 'date found' column to auto-populate the date when information is entered to make it easier for tracking purposes.

Date Found (Column B) and Date Corrected (Column H) were taken and initially using a subtraction formula yielded no results. I also used =DAYS() and =DATEDIF() and it did not yield results. I only got a return value of zero. I even tried to nest the above formula into the 'Days' and 'DatedIf' functions which also yielded zero. When I click into the formula--it does display the correct value as far as dates go, but on the document itself--I see zero.

Is there a way to make it so I can see the actual calculated difference or do I even need this 'Date Difference' column? Can I just pivot the data I need to begin with?

Answer 1

Hi @Nasar Kamal

Could you please share us with a simple sample for more information?

• If possible, you may save the sample as .xml file and upload it here.
• Please note, delete or change the important and privacy data.

How did you get the dates for Date Corrected (Column H)?

Please check cell format for dates in Date Found (Column B), its source data and Date Corrected (Column H), ensure they are in Date format of MM/DD/YYYY.

Based on my test, using subtraction, subtract the Date Found date from the Date Corrected date to get the date difference.

I suggest you click one cell of "Cell Difference", click Formulas tab > Evaluate Formula, click "Evaluate" to show the calculation process. Make sure the formula for Data Difference refers to the correct cells.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment". Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

---