Forum Home
Press F1
Thread ID: 66685	2006-03-04 03:41:00	Excel Formulas	csinclair83 (200)	Press F1

Post ID	Timestamp	Content	User
435341	2006-03-04 03:41:00	Hey :) Am currently doing some Excel work, and from the computer course I did a while back, i recall some formulas, and so far they work, but the next formula i want to use is being a a$$ I require to measure the time between 2 certian dates. and I know it uses the Days 360 formula... the cells i wanna use are A8 and A9..and the dates shown are 1/4/2003 and 29/12/2003..i'm sure i can work it out manaually but as i'll be adding dates as i go, so would take way too long. I entered formula as =Days360(A8:A9) and it gives the value# error, and the help doesnt even help lol. I cant figure out why its giving a error as I went to the microsoft exel website and it said formula is Days360(start date:enddate) so i'm stuck for some reason.. AM using Excel 2004 Cheers	csinclair83 (200)
435342	2006-03-04 04:41:00	Its not (A8:A9), its (A8,A9) comma, not colon. But if you want the actual number of days, simplt subtract =A9-A8 The anwer will appear as an odd looking date, just reformat the cell as general and it will have the number of days. Excel will perform arithmetic on dats just fine, as long as the cell with the formula in it is not a date format.	godfather (25)
435343	2006-03-04 06:12:00	I think theres something wrong with EXCEL, have just adjusted the colon to be a comma...failed...so moved to colon, said i gave too few arguements...so i decided to try your A9-A8 and it gave same value answer as #VALUE! so obviously something wrong with excel picking up my formulas is there? Can you help me repair?	csinclair83 (200)
435344	2006-03-04 20:38:00	your formula should look like this: =days360(a8,a9) Works fine for me. I tried GFs suggestion of =a9-a8, and there is a difference of 4 :) not sure why yet. The formula has to use a comma, not a colon - a colon indicates a range of cells, and you just want one cell for each part of the formula. Commas separate the different parts of the formula. Are you doing this on a Mac? If not, then I doubt you're using Excel 2004 :D Just to be pedantic about it ;) Mike.	Mike (15)
435345	2006-03-04 20:40:00	I tried GFs suggestion of =a9-a8, and there is a difference of 4 :) not sure why yet.Bah! I know why :) Because we're using a 360 day year, not a 365 day year, so it doesn't take into account the 31 day months :D So in other words the =a9-a8 would be more accurate than using the days360() method. Mike.	Mike (15)
435346	2006-03-04 20:43:00	I think theres something wrong with EXCEL, have just adjusted the colon to be a comma...failed...so moved to colon, said i gave too few arguements...so i decided to try your A9-A8 and it gave same value answer as #VALUE! so obviously something wrong with excel picking up my formulas is there? Can you help me repair?Have you set up some odd kind of formatting for your date fields? Or are you just using the standard date cell format? Mike.	Mike (15)
435347	2006-03-04 21:07:00	Morning guys! I;m using Office XP Excel.... and "odd formatting" for date feilds, dont know what you mean, but when i highlight 2 cells and right click, go to format cells, and under number, its on "date" and under type its 3/14/2001 (thats the example they use to show order the date would come out) and location is European (united states) I've tried A8-A9 and a8-a9 and the days360(a8,a9) and days360(1/4/2003,29/12/2003) and none of them work...i knew the last one wouldnt but had to try,	csinclair83 (200)
435348	2006-03-04 21:34:00	Morning guys! I;m using Office XP Excel.... and "odd formatting" for date feilds, dont know what you mean, but when i highlight 2 cells and right click, go to format cells, and under number, its on "date" and under type its 3/14/2001 (thats the example they use to show order the date would come out) and location is European (united states) I've tried A8-A9 and a8-a9 and the days360(a8,a9) and days360(1/4/2003,29/12/2003) and none of them work...i knew the last one wouldnt but had to try,Why do you have the US date format and not the NZ date format? it seems a bit odd that you'd be able to use the date 29/12/2003 if the format is mm/dd/yyyy... Try changing your date format to be dd/mm/yyyy instead. Mike.	Mike (15)
435349	2006-03-04 21:35:00	I've tried A8-A9 and a8-a9 and the days360(a8,a9) and days360(1/4/2003,29/12/2003) and none of them work...i knew the last one wouldnt but had to try,the last one should work if you put the dates into quote marks, as below: =days360("1/4/2003","29/12/2003") Mike.	Mike (15)
435350	2006-03-04 21:38:00	Why do you have the US date format and not the NZ date format? it seems a bit odd that you'd be able to use the date 29/12/2003 if the format is mm/dd/yyyy... Try changing your date format to be dd/mm/yyyy instead. Mike. I use the US date format, because when I use any other formats, somehow the formats change themselves, and when I right click and go to number/date etc, it shows armenian date format?!?!?!?! and i came on here about that, and couldnt work it out, so i gave up and left it on the USA one...and ur right its odd that I could sue the date 29/12/2003 when its mmddyyyy....its coz I wrote it on here wrong, it is actually mm/dd/yyyy (habit of writing days before month for years then having to adjust for one program isnt that easy lol)	csinclair83 (200)
1 2 3