| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
DATE COMPUTATIONS
alright perhaps I am too much of a novice to understand
how do I do this? 1 2 3 a 1990 01 25 1993 07 21 =a2-a1 (displayed as "03 09 16") b 1993 07 22 1999 04 29 =b2-b1 (displayed as "06 02 23") c (sum a3+b3 displayed as yyyy mm dd) I have been working on this for a while and it seems impossible |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
DATE COMPUTATIONS
http://www.cpearson.com/excel/datedif.aspx
-- David Biddulph "sonarmark" wrote in message ... alright perhaps I am too much of a novice to understand how do I do this? 1 2 3 a 1990 01 25 1993 07 21 =a2-a1 (displayed as "03 09 16") b 1993 07 22 1999 04 29 =b2-b1 (displayed as "06 02 23") c (sum a3+b3 displayed as yyyy mm dd) I have been working on this for a while and it seems impossible |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
DATE COMPUTATIONS
Format column 3 as general, or as a number, so it displays the way you want
it. There's nothing wrong with your computations. Regards, Fred. "sonarmark" wrote in message ... alright perhaps I am too much of a novice to understand how do I do this? 1 2 3 a 1990 01 25 1993 07 21 =a2-a1 (displayed as "03 09 16") b 1993 07 22 1999 04 29 =b2-b1 (displayed as "06 02 23") c (sum a3+b3 displayed as yyyy mm dd) I have been working on this for a while and it seems impossible |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date formats and computations -- Help | Excel Worksheet Functions | |||
| Freeze screen during computations | Excel Discussion (Misc queries) | |||
| Report Date - Date Recv = Days Late, but how to rid completed date | Excel Worksheet Functions | |||
| Computations involving text cells are not working?? | Excel Worksheet Functions | |||
| Date updates from worksheet to chart & changes date to a date series! Help!! | Charts and Charting in Excel | |||
Linear Mode
