If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Averaging dates, doesn't see them all as numbers
Hi all, i've started to average some dates for a user. To
make sure the values to be averaged are numbers, i used: =IF(AND(ISNUMBER(I122),ISNUMBER(A122)),I122-A122,"") This is autofilled for about 200 rows. The issue is that now some of the dates are not being calculated by their serial numbers. The answer to the above formula stays blank until i go into either I122 or A122 and reenter the date (or just by editing and hitting enter). Is there a way to fix this? Excel XP. TIA, Kevin M |
#2
|
|||
|
|||
Hi
sounds like your dates are NOT stored as real date value but as 'text' values. Do you import these date values? -- Regards Frank Kabel Frankfurt, Germany "Kevin M" schrieb im Newsbeitrag ... Hi all, i've started to average some dates for a user. To make sure the values to be averaged are numbers, i used: =IF(AND(ISNUMBER(I122),ISNUMBER(A122)),I122-A122,"") This is autofilled for about 200 rows. The issue is that now some of the dates are not being calculated by their serial numbers. The answer to the above formula stays blank until i go into either I122 or A122 and reenter the date (or just by editing and hitting enter). Is there a way to fix this? Excel XP. TIA, Kevin M |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
text numbers as dates via OCR import | Dave Peterson | General Discussion | 1 | August 20th, 2004 01:57 PM |
Change Start Dates without Changing Due Dates | Beth | General Discussion | 0 | August 19th, 2004 03:44 PM |
Calculating days between two dates and multiply them with different numbers | [email protected] | Worksheet Functions | 3 | June 1st, 2004 06:36 PM |
Top ten highest numbers! | Jason Morin | Worksheet Functions | 5 | May 26th, 2004 04:02 PM |
subtracting dates to give a whole number | Lasitter | Worksheet Functions | 2 | October 1st, 2003 09:14 AM |