| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel date funtion
Is there a simple way to calculated the number of months between two dates?
Also is there a way to change the default date display format from a four year to a two year format (7/10/2006 to 7/10/06) so that all my entries will always show the two year format? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel date funtion
Hi Craig
See http://www.cpearson.com/excel/datedif.htm Ctrl-1 NumberDate the format is in the list Or NumberCustom Enter mm/dd/yy -- Regards Ron de Bruin http://www.rondebruin.nl "Craig" wrote in message . .. Is there a simple way to calculated the number of months between two dates? Also is there a way to change the default date display format from a four year to a two year format (7/10/2006 to 7/10/06) so that all my entries will always show the two year format? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel date funtion
"Craig" wrote in message
. .. Is there a simple way to calculated the number of months between two dates? http://www.cpearson.com/excel/datedif.htm Also is there a way to change the default date display format from a four year to a two year format (7/10/2006 to 7/10/06) so that all my entries will always show the two year format? Not Excel, but a Windows function, I think. Try Regional Options/ Short Date. -- David Biddulph |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calendar Control in Excel 2000 can't display date in Excel 2003? | Excel Discussion (Misc queries) | |||
| Excel date format trouble | Excel Discussion (Misc queries) | |||
| TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
| Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
| Excel formula with date constraints | Excel Discussion (Misc queries) | |||
Linear Mode
