Related:
- Convert date into Month and Year to use > <
- Convert m3u to mp3 - Guide
- Convert picture to shape powerpoint - Guide
- How to convert number into words in ms word in shortcut key - Guide
- How to convert free fire id facebook to google - Guide
- Convert dts to ac3 mkvtoolnix - Guide
Aug 25, 2017 at 08:50 AM
thanks for the suggestion. unfortunately no dice.
of the 2 dates i have, in E2 and K2, it is possible that either E2 or K2 is earlier than the other. so if i use DATEDIF(E2,K2,M) it returns a value if the dates are exactly the same (0) or if K2>E2, but in cases where E2>K2 it returns the #NUM! error.
This would be okay as then i would know all #NUM! error really mean that E2>K2 but it is giving the same error if E2>K2 and is in the same month as K2. so 10/04/2016>10/01/2016 when i would need those to show as 0.
ive found a only slightly tedious work around, im just going to update every date within the month to the 1st of the month for both data sets and then i can use my original plan.