Calculator to calculate year, months and days

Good day

i have this excellent calculator that when you type in a date and press the calculate button, it shows in a label how many years, months and days it is until today.

the problem is i also want the user to input the date on a stamp and a manual date to calculate the years, months and days in a separate label.

Example

you have a office that checks the validity of a document and that documents must no be older than 6months.

if you want to verify that the date on the document and the date the person was there, you should be able to.

please help

Hi there,

Maybe my birthday occurred on a "special" date, but:

when I enter a value of 22/10/2000, the output is "21 year(s), 11 month(s), 24 day(s)

when I enter a value of 22/11/2000, the output is "19 year(s), 10 month(s), 24 day(s)

I haven't investigated the calculations yet, but there's obviously something wrong!

Regards,

Greg M

sorry for that. my computer date is set to dd/mm/yyyy but i use yyyy/mm/dd on the calculator.

dont worry about that. what happens is when u type the date on a document, it will calculate the years, months and days until today. that is fine.

i want when you as a supervisor like VERIFY afterwards the years, months and days from the date of the document to the date that the person came to your office.

thats why i created two seperate textboxes and a label.

ok thank you. if you type in the date that is on the document eg 13/01/2020 it shows 9months and 2 days. That is correct because it calculated from that date until today. Computer date and time.

i want two separate textboxes on the same userform where u type in the date of the document eg 13/01/2020 until any date that u can manually put it.

Scenario. the policy at your company is that when someone brings a certain document. the person working at the counter must verify if that document is still valid. lets say 4 months.

u are the supervisor so when u check that "transaction" after a week or a month, u would like to confirm whether that document was indeed valid. so u type in the date of the stamp of the document and the date the client came to your company.

two separate textboxes with a command button where the new result shows in another label.

Thank you for your time in helping me. I thank you for it

thank you it works like a charm! you are truly a Forum Guru.