Last seen: Jan 15, 2026
Hello. Yes well I understand what you're saying. It is to show how to in a Formula, a progress in works, TAB with red question is a 1 CELL approach ...
Hello. Thanks for constructive critisim, I did miss it, forget to leave ref'd, as was busy adding eDocs, perhaps you can ad it to btm (a joke)! Appr...
So... CONCATE DATEIF is probably as good as it gets, unless some of you, an XL GENIUS have better ideas? But what about a simple/basic subtract..??? ...
UPDATE: Best abbreviated DATEIF so far... =CONCAT(DATEDIF(A1,B1,{"y","ym","md"})&{" Year "," Mth "," Day "})&TEXT(B1-A1,"h\Hr m\M")
@riny Also I appreciate comments including...to effoect you don't have to do any of that or it is confusing, which led me to see how it (DATE-TIME FOR...
However without CONVERT the calculation with SUBTRACT/NEGATIVE of NUMBER DECIMAL is incorrect with DATASETS where the Result is that it does not equal...
so if 2 DIFFERENT DATES (FINISH - START) = HOURS ACTUAL (NOT DECIMAL)What is correct FORMULA & FORMAT CELLS? Custom? Ain't it odd basic SUBTRACT (...
Hello What's the Difference between 2 Dates! ? Solved Solution is: =CONVERT(F25-C25,"day","hr") It looks so simple and gladly...
Hello Solved the 3D Indirect Alphanumeric Year myself, 2 versions attached, both 3D Indirect Tabs summary. 1. YEAR date TAB names. 2. Alphanu...