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 03:46 AM.
Perhaps like this:
--A--- -B- --C--- ----------------------D----------------------- 1 17.001 150 18.039 C1: =DOLLARFR(DOLLARDE(A1, 112) + B1/112, 112)
Microsoft MVP - Excel
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 inverted--A--- -B---- -C- ----------------------D----------------------- 1 17.001 18.039 150 C1: =(DOLLARDE(A1;112)-DOLLARDE(B1;112))*112
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
Reply With Quote
Bookmarks