About this thread: http://www.excelforum.com/excel-new-...in-a-year.html
What if I want to calculate the age adding number of days passed from first age?
For example: I have the starting age of 17.001; 150 days was passed from that date (1 year and 38 days), so the result age must be 18.039. How to calculate it inverting the formula to calculate days between two ages?
thank you
Last edited by alecs81; 11-23-2011 at 04:46 AM.
Perhaps like this:
Please Login or Register to view this content.
Entia non sunt multiplicanda sine necessitate
It doesn't work, I got an error in the formula.Originally Posted by shg
In the other thread the formula is like this
need it invertedPlease Login or Register to view this content.
Replace commas (,) with semi-colons (, i.e. use this version of shg's formula
=DOLLARFR(DOLLARDE(A1; 112) + B1/112; 112)
Audere est facere
seems it works!! thanks a lot :D
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks