Since not all months have 30 days, there are more issues than just dealing
with leapyears.

For example:
Contract Start Date: 02/28/2006
Does that mean it ends on the 28th of the last month? or the end of the month?
Same issue for months ending on the 30th.

Hopefully, your contracts address the situation by specifying an expiration
date.

If your spreadsheet is meant, in part, to act as a reminder you might want
to flag contracts approaching the calculated expiration date.

I hope that helps.

***********
Regards,
Ron

XL2002, WinXP-Pro


"Phil" wrote:

Hi Ron,

I went with Option 2, I tried that and it works GREAT! So that is what I
will go with. With regard to Option 1, if I were to send the spreadsheet to
someone else (like the client), they would have to be sure to have the Add-In
loaded as well, right? And if they didn't what would happen? Would the
dependent cell (on the Add-In) be blank, then?

HOWEVER, I realized after sending my first post that there ARE going to be
contracts that will be 18 AND 24 months, and that would put some of the
expiration dates into 2008, which is a Leap year.

What is(are) your opinion(s) on the Leap year issue?

Thanks again in advance for your replies.

Phil



"Ron Coderre" wrote:

Here are 2 options:

For data in Row_2

1) I2: =EDATE(G2,H2)
Note: the EDATE function is part of the Analysis ToolPak add-in. You might
need to enable or install it. (<Tools<Add-ins...etc)

2) I2: =DATE(YEAR(G2),MONTH(G2)+H2,DAY(G2))


For days remaining:
J2: I2-F2
(formatted as a number)

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Phil" wrote:

Hello,

I have five columns shown below, with sample values after the colon

(Col F) Today's Date: 04-28-06 {this will be using the =TODAY() function}
(Col G) Contract Date Signed: 03-28-06
(Col H) Duration (Months): 12
(Col I) Expiration Date: 03-28-07*
(Col J) Days Remaining in Contract: 334*

* these are hypothetical, they are not correct

If the user puts 12 in column H, for the duration, the result will be
03-28-07.

But what if someone puts something other than 12, like 8, 6, 7, or 13? I
need someway to be able to get Excel to tell me the EXACT day that the
contract will expire, AND how many days are left in the contract. BTW, the
user will ALWAYS be entering whole numbers, not decimals, eg. 6.5 months.

Thanks in advance for your responses.

Phil.