| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Insert Automatic, Non-Updating Date Stamp | Excel Discussion (Misc queries) | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
| Adding XY days to date in cells | Excel Discussion (Misc queries) | |||
| Another Date issue. | Excel Worksheet Functions | |||
| Date Math Problem | Excel Worksheet Functions | |||
Hybrid Mode
