Date Help

W

walkerdayle

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?

:)
 
W

walkerdayle

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

Ron Rosenfeld

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

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

manxman

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

Fred Smith

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