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

Post ID	Timestamp	Content	User
435361	2006-03-05 00:44:00	did that, it gave answer as 31? which answer is more correct? as i dont want to be 1 day wrong?	csinclair83 (200)
435362	2006-03-05 00:44:00	btw thank you soooooooooooooo much for your help with all this :) I really appreciate it :)	csinclair83 (200)
435363	2006-03-05 00:53:00	But the answer is 42. Always. :D	Graham L (2)
435364	2006-03-05 00:55:00	u just trying to confuse me again arent ya :P i counted on a calender after i wrote the thanks message so i know 42 is wrong :P nice try thou :D	csinclair83 (200)
435365	2006-03-05 01:05:00	Oh dear. :( 42 (en.wikipedia.org/wiki/The_Answer_to_Life,_the_Universe,_and_Everything)!	Graham L (2)
435366	2006-03-05 01:55:00	did that, it gave answer as 31? which answer is more correct? as i dont want to be 1 day wrong?31 is the correct answer. Using the days360 method you won't get the correct answer (but it'll usually be close) as it's based on 12 months of 30 days (360 days total)... but there are not 12 months of 30 days; 7 months have 31 days, 4 months have 30 days, and February has either 28 or 29. So in other words, the b2-a2 method will be more accurate in this case. Cheers, Mike.	Mike (15)
435367	2006-03-05 02:21:00	Forty-two!" yelled Loonquawl. "Is that all you've got to show for seven and a half million years' work?" "I checked it very thoroughly," said the computer, "and that quite definitely is the answer. I think the problem, to be quite honest with you, is that you've never actually known what the question is." ...	Graham L (2)
435368	2006-03-05 03:02:00	yep using that process and all is working now :D thanks so much for your help :)	csinclair83 (200)
1 2 3