Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]() 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. 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. I hope the above way was not too clumsy a way of explaining my point. :) cheers shaunl -- shaunl ------------------------------------------------------------------------ shaunl's Profile: http://www.excelforum.com/member.php...o&userid=25140 View this thread: http://www.excelforum.com/showthread...hreadid=386345 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
calculate anniversary of date after specified date | Excel Worksheet Functions | |||
Calculating days between current date and a date in future NETWORKDAYS() function | Excel Worksheet Functions | |||
Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
How to change (delivery) days and automatically the receive date in an other cell? | Excel Worksheet Functions | |||
Calculate # of Days from one date to another | Excel Worksheet Functions |