Calcul of the duration

D

Dominique

How can I know howmany years, month and days has been pass
between two date (Excel function)
Thanks for any help
 
B

Bernard Liengme

Use DATEDIF. This is an undocumented function (except in one version, XL2000
I think). See Chip's site for full details www.cpearson.com
Best wishes
Bernard
 

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

Expanding Date Formula 0
Calculating time for 3rd shift 4
Percentage of month passed formula 1
MS Project. Real progress of the project, % complete 1
XIRR vs. IRR Function 11
Receiving unexpected Duration 0
Sharing Excel 365 Mac<->PC 0
Gantt chart duration not showing 0

Top