Hi,
How Do I Convert years, months, days back
to complete days
A2 = 2 years
B2 = 6 Months
C2 = 27 Days
Hi,
How Do I Convert years, months, days back
to complete days
A2 = 2 years
B2 = 6 Months
C2 = 27 Days
=a2*365+b2*365/2+27
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
What is the expected result?
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Thanks FDibbins, it works.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks