Try this formula in D1 instead, then can you make it fit what you need?
=ROUND((B2/(TODAY()-DATE(2012,4,1)))*365,0)
Try this formula in D1 instead, then can you make it fit what you need?
=ROUND((B2/(TODAY()-DATE(2012,4,1)))*365,0)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks