Your post kept me from having to ask the question Thank you

"Karthik" wrote:

Sorry i am not clear of your query but this formula will give you the
duration between 2 dates

in A1 enter the first date, B1 enter the second date and in C1
=datedif(A1,B1,"d")
d represents days
m represents months
y represents years

Hope this is on similar lines