Difference between dates as # of months, # of days, # of years

I

Iago

I have cell A1 as 4/4/08 and B1 as NOW()
How can I show the difference as: # months # days #years in one cell
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

find out specific month and year 1
Expanding Date Formula 0
Extract Month and year from Cell containing date, month, year & time 2
Send meeting request for different dates (no repetition) to different people 0
Show value from one cell in another cell if today falls between a date range 5
date mismatching 2
Calendar Logic: Recurring Dates 3
Search closest day in the past from today 2

Top