LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
shaunl
 
Posts: n/a
Default 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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
calculate anniversary of date after specified date slymeat Excel Worksheet Functions 3 July 5th 05 01:53 AM
Calculating days between current date and a date in future NETWORKDAYS() function Faheem Khan Excel Worksheet Functions 2 February 10th 05 07:18 PM
Addition to Turn cell red if today is greater or equal to date in cell Rich New Users to Excel 2 December 9th 04 02:06 AM
How to change (delivery) days and automatically the receive date in an other cell? Elboo Excel Worksheet Functions 5 November 22nd 04 02:44 PM
Calculate # of Days from one date to another jscano Excel Worksheet Functions 2 November 11th 04 03:23 AM


All times are GMT +1. The time now is 07:34 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"