Is there a way to put a date in one cell, then have a count in days from that date-to-today in another cell, a count in months from that date to this month today in a third cell, and another count in years from that-date-to-today’s year in a fourth cell? I can find a LOT of date functions, but not one that will do that in reference to whatever the current date is. More than likely it’s there and I just can’t find it, or I’m just not creative enough to use the existing functions in combination to get this result. Any help would be greatly appreciated!
Hi Hrbrgr,
Well, that’s certainly what I’m looking to do!
I’m trying to make some sense of the examples provided in the link you posted. I’ll give it a whirl once I figure it out and let you know. Thanks for your input.
It should be obvious that you need to incorporate one of the functions which returns already the current-date →→ NOW() or TODAY() are your friends.
for example:
=DATEDIF($A$1;TODAY();{"y"."ym"."md"})
calculates years, remaining months and remaining days, between date in A1 and current Date, into 3 cells side by side.
1 Like
Hi Karolus,
Tried your solution (date to count from is in cell B2, so I changed the $A$1 term to read $B$2…) I pasted the formula you posted in the cell adjacent to B2, and the result was “Err: 501.” Thanks for your suggestion, though… it’s another avenue to pursue.
The Err:501 is probably due to the odd . dot column separator karolus uses in {"y"."ym"."md"} (can be done in a locale that uses comma as decimal separator); replace the dots with , comma or whatever you use in Tools → Options → Calc → Formula, Separators, Array column.