# Solved: Fooling Excel 2007 with dates

Discussion in 'Business Applications' started by bleep69, Sep 15, 2011.

Not open for further replies.
1. ### bleep69Thread Starter

Joined:
Nov 21, 2008
Messages:
132
Hi,

I have a spreadsheet that calculates how long a contract has left to run, using the following formula:

=((EDATE(R5,S5))-TODAY())/30

where R5 is the start date of the contract, and S5 is the duration of the contract.

I need to make the spreadsheet think that it's June, and not today, but I'm struggling. Does anyone have a suggestion?

2. ### bleep69Thread Starter

Joined:
Nov 21, 2008
Messages:
132
Answered my own question with a bit more fiddling. Just converted the date to a number and subtracted it.

3. ### KeebellahTrusted Advisor

Joined:
Mar 27, 2008
Messages:
6,568
First Name:
Hans
You could also have a cell that always contains the actual date let's say D1=TODAY()
ans then you can have a cell beside it to entre a number of days:

D1=TODAY() E1=0 F1=D1+E1

So Cell E1 = number of days forward (- for backwards) and F1 contains the results

4. ### bleep69Thread Starter

Joined:
Nov 21, 2008
Messages:
132
Thanks Keebellah!

As Seen On

### Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

over 733,556 other people just like you!