Hi,
I'm trying to find the date difference between transaction dates and expiration dates. These two fields are in different rows.
My goal is try to find the amount of time before or after someone's expiration date. I tried using DATEDIF but it's returning #NUM! errors and doesn't return negative results. Can I use a pivot table to view the number of months between dates sorted by ID?
Thank you!
Can you be more specific as to which dates you are trying to compare. If you take some of your data you have shown and provide a manually prepared mock up we might understand better what you are after.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Guessing as to what you want.
Excel 2016 (Windows) 32 bit
ID TranDate ExpDate Days Difference
Sheet: Table1
Power Query Mcode
Please Login or Register to view this content.
Sorry I should have specified that in my initial question. For ID 49, I want to compare 1/2/2019 to 5/29/2019 (C2, B3). For ID 75, 12/31/2018 to 12/7/2018 (C4, B5) and 12/31/2019 and 11/29/2019 (C5, B6). Thanks!
ID Transaction date Expiration Date
49 1/2/2017 1/2/2019
49 5/29/2019 11/29/2020
75 2/5/2018 12/31/2018
75 12/7/2018 12/31/2019
75 11/19/2019 6/30/2021
Try this in D2:
=IF(A2=A3,B3-C2,"")
Oh wow that worked! Thanks so much!
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.
Thank you for the tips! Very helpful.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks