Date Help
 

Hello all,
How do I calculate a future date? For example, say a person signs a
Lease today, 3/17/06. I'd like to know what the lease renewal date
would be for a 2 year lease. Thank you

Also, is there a way to create a custom format that doesn't round up
numbers?

:)


--
walkerdayle
------------------------------------------------------------------------
walkerdayle's Profile: http://www.excelforum.com/member.php...o&userid=10021
View this thread: http://www.excelforum.com/showthread...hreadid=523604

Date Help
 

Hi

Try this:
=DATE(YEAR(C32)+2,MONTH(C32),DAY(C32))
If the start date is 29th Feb, the end date will be 1 March.

Andy.

"walkerdayle"
wrote in message
...

Hello all,
How do I calculate a future date? For example, say a person signs a
Lease today, 3/17/06. I'd like to know what the lease renewal date
would be for a 2 year lease. Thank you

Also, is there a way to create a custom format that doesn't round up
numbers?

:)


--
walkerdayle
------------------------------------------------------------------------
walkerdayle's Profile:
http://www.excelforum.com/member.php...o&userid=10021
View this thread: http://www.excelforum.com/showthread...hreadid=523604

Date Help
 

Thanks Andy, I'll try it. You wouldn't have any thoughts to the second
question? But, once again, thank you!


--
walkerdayle
------------------------------------------------------------------------
walkerdayle's Profile: http://www.excelforum.com/member.php...o&userid=10021
View this thread: http://www.excelforum.com/showthread...hreadid=523604

Date Help
 

On Fri, 17 Mar 2006 10:05:37 -0600, walkerdayle
wrote:




Also, is there a way to create a custom format that doesn't round up
numbers?

Any number format that limits the number of decimals displayed will round.
--ron

Date Help
 

There is something called "Precision as displayed", in Options. Be careful
as it changes the underlying values.

"Ron Rosenfeld" wrote:

On Fri, 17 Mar 2006 10:05:37 -0600, walkerdayle
wrote:




Also, is there a way to create a custom format that doesn't round up
numbers?

Any number format that limits the number of decimals displayed will round.
--ron

Date Help
 

To get A1 + 2 years

=EDATE(A1,24)

EDATE requires analysis toolpak addin


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=523604

Date Help
 

All *formats* will round the result. If you want to eliminate rounding, change
your formula to incorporate the INT or ROUNDDOWN functions.

--
Regards,
Fred


"walkerdayle" wrote
in message ...

Thanks Andy, I'll try it. You wouldn't have any thoughts to the second
question? But, once again, thank you!


--
walkerdayle
------------------------------------------------------------------------
walkerdayle's Profile:
http://www.excelforum.com/member.php...o&userid=10021
View this thread: http://www.excelforum.com/showthread...hreadid=523604