| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Gary's Student Part 3 or Anyone else
I might not have explained correctly, sry for that If A1=12/10/08, and i
input a compltetion date B1=12/11/08= my answer in C1= (1) which is correct. My Question is that how do i make C1 display ZERO instead of 39796. if i do not enter a number into B1, C1 comes up 39,796 which is a problem when i am trying to add the total amount of days we are behind or on schedule. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Gary's Student part 2 or Question 2 on excel spreading Dates evenl | Excel Discussion (Misc queries) | |||
| Map Network Drive FAO Gary's Student | Excel Discussion (Misc queries) | |||
| To Gary's Student | Excel Discussion (Misc queries) | |||
| To: Gary's Student cell address reply | Excel Discussion (Misc queries) | |||
| Is Gary's Student here | Excel Discussion (Misc queries) | |||
Threaded Mode
