Years = INT(D/365)
Months = INT(MOD(D,365)/30)
Days = MOD(MOD(D,365),30)
Assuming of course a 365 day year and 30 day month. If you want to put those
together, use CONCATENATE()
HTH
RJK
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.