Question:

Is there a way in Excel to find what date changes from original date to new date?

by  |  earlier

0 LIKES UnLike

For example, out of a 100 sales, I want to find if any factory schedule has changed. Is there a formula to find when date changes?

 Tags:

   Report

1 ANSWERS


  1. Say that A1 has the original date, and B1 has the new date.  To determine if A1 matches B1, use the following:

    =IF(A1=B1, "same", "different")

    If that doesn't help, try providing more details in your question.  What data is there to base the solution on?

Question Stats

Latest activity: earlier.
This question has 1 answers.

BECOME A GUIDE

Share your knowledge and help people by answering questions.