Date/time passed formula
I have a cell with a date in it, ie 25/08/2007, and I would like the next cell to display how much time has passed from this date to today, ie 7 months 1 day.
I can't for the life of me fathom out how to do this. Any ideas would be very gratefully accepted.
Hane a look at
If require just months & days use a modified version of the Calculating Age formula
=DATEDIF(A1,TODAY(),"ym")&" months "&DATEDIF(A1,TODAY(),"md")&" days"
Please Read Forum Rules
Wrap VBA code by selecting the code and clicking the # icon or Read This
How To Cross Post
Top Excel links
for beginners to Experts
If you are pleased with a member's answer then use the Scales icon to rate it
If my reply has assisted or failed to assist you I welcome your Feedback.
Thanks for your help. I've tried it, and changed the cell references to the relevant cells in my sheet and it returns a #NUM! error. Any ideas?
I do not know what would cause the #NUM! error.
If the formula refeneces a non numeric value I get a #VALUE! error
I have not been able to duplucate your #NUM! error.
I've got it to work by using the following formula:
It only returns the #NUM! error when items aren't yet out of date.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1