| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
how to calculate a date .. say 34 days from today
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 |
|
#2
|
|||
|
|||
|
Not at all, Shaun. This is a no-brainer.
A1 has your date B1 has your number of days (94) In C1, type: =A1+B1 A1 and C1 must both be formatted as dates. If it doesn't appear to work for you, select A1 and C1 and hit Format--Cells and choose Date, and choose one of the date formats. ******************* ~Anne Troy www.OfficeArticles.com "shaunl" wrote in message ... 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 |
|
#3
|
|||
|
|||
|
=TODAY()+A1
-- Kind regards, Niek Otten Microsoft MVP - Excel "shaunl" wrote in message ... 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 |
|
#4
|
|||
|
|||
|
awesome! thanks kindly guys. :) Cheers Shaun L -- shaunl ------------------------------------------------------------------------ shaunl's Profile: http://www.excelforum.com/member.php...o&userid=25140 View this thread: http://www.excelforum.com/showthread...hreadid=386345 |
|
#5
|
|||
|
|||
|
shaunl Wrote: awesome! thanks kindly guys. :) Cheers Shaun L You are welcome ... thanks for the feedback. Regards. -- BenjieLop ------------------------------------------------------------------------ BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019 View this thread: http://www.excelforum.com/showthread...hreadid=386345 |
|
#6
|
|||
|
|||
|
<< 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| 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 | |||
Hybrid Mode
