<< Hi all,
first time i have been here - so apols in advance if this is a basic
question. I have looked a few places for some help on this but to no
avail.
I would like to do this:
1. create a calculation that is a numbers of days in a cell. In this
case it is to calculate how many days a set amount of money will last.
BASED ON THE ABOVE STATEMENT, I ASSUME THAT YOU ALREADY HAVE A FORMULA
FOR CALCULATING THE NUMBER OF \"DAYS A SET AMOUNT OF MONEY WILL LAST.\"
LET US ASSUME THAT THIS IS IN CELL A1
<< 2. I would then like a new cell to take that calculation from the
cell above and then forecast what date that would be.
So, if i have determined that i have 94 days left of operations with a
set amount of money in the bank, excel can automatically tell me what
date that will be from today's date, along the lines of:
=today's date + 94 days = forecast date.
In Cell B1, enter this formula
=TODAY() +A1
Hope this will help you.
Regards.
--
BenjieLop
------------------------------------------------------------------------
BenjieLop's Profile:
http://www.excelforum.com/member.php...o&userid=11019
View this thread:
http://www.excelforum.com/showthread...hreadid=386345