how to calculate a date .. say 34 days from today

S

shaunl

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
 
B

BenjieLop

<< 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.
 
A

Anne Troy

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to calculate with workingdays instead of calendar days 4
Excel How to create a Accounts Receivable to calculate days in which payments against invoice are received 0
Calculate the number of days from a specific date 5
How do I add a range by date over 90 days older than today 4
Count Number of Days after a Start Date 4
Counting calendar Days - not including Sundays 3
Network days 3
Date Formula for number of days between a date and today 7

Top