Home |
Search |
Today's Posts |
#1
|
|||
|
|||
difference between two dates
I would like to know how to have one cell contain the Today() function and another cell contain a "date" in the future, where yet another cell will calculate how many days left until the future date. I am getting results like 08/09/1900. All I want is a number Thanks -- dhouston1000 ------------------------------------------------------------------------ dhouston1000's Profile: http://www.excelforum.com/member.php...o&userid=26570 View this thread: http://www.excelforum.com/showthread...hreadid=398454 |
#2
|
|||
|
|||
Change the number format of the result cell to General.
Regards Rowan "dhouston1000" wrote: I would like to know how to have one cell contain the Today() function and another cell contain a "date" in the future, where yet another cell will calculate how many days left until the future date. I am getting results like 08/09/1900. All I want is a number Thanks -- dhouston1000 ------------------------------------------------------------------------ dhouston1000's Profile: http://www.excelforum.com/member.php...o&userid=26570 View this thread: http://www.excelforum.com/showthread...hreadid=398454 |
#3
|
|||
|
|||
In Cell A1 enter 11/27/2005 (Format, Cell, Date)
In Cell B1 enter =today() (Format, Cell, Date) In Cell C1 enter =a1-b1 (Format, Cell, General) Cell C1 should show 95 (at least today, 8/24). HTH "dhouston1000" wrote in message news:dhouston1000.1u8xic_1124849106.5194@excelforu m-nospam.com... I would like to know how to have one cell contain the Today() function and another cell contain a "date" in the future, where yet another cell will calculate how many days left until the future date. I am getting results like 08/09/1900. All I want is a number Thanks -- dhouston1000 ------------------------------------------------------------------------ dhouston1000's Profile: http://www.excelforum.com/member.php...o&userid=26570 View this thread: http://www.excelforum.com/showthread...hreadid=398454 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula to find the working days difference between to dates? | Excel Discussion (Misc queries) | |||
Calculate Difference b/e 2 dates. | New Users to Excel | |||
compute the difference between two dates accurately | Excel Discussion (Misc queries) | |||
i NEED THE DIFFERENCE OF DATES DOWN TO YEARS...IE 11/1/02-4/16/85. | Excel Worksheet Functions | |||
How do I calculate difference in days & hours between two dates e. | Excel Worksheet Functions |