I'm trying to 'digitise' a fuel log for my car. You know, dates, fill amount, cents per litre (metric here people), total cost etc.
However, there is a strange problem in MS Excel 2004. I'm trying to make excel give me the day of the week a that date fell on using the WEEKDAY() function. But the day it gives me is one early, ie Monday should be Tuesday. (see attachment)
So I figure out that the ENTIRE "WEEKDAY()" function is exactly one whole day off for every single date (from 1904 right through to 2008, using iCal).
Is there anyway to fix this problem (Googling yielded no results)? I tried doing '=WEEKDAY("date") +1' which fixes the problem, only now, Sunday doesn't exist. And, I tried using a custom cell format "DDDD" with the date itself (no formulas, it'll give me the correct weekday, but other problems arise with the fact that the format in that cell is no longer a integer, but still a date format.
Any help?
Cheers,
Sam
However, there is a strange problem in MS Excel 2004. I'm trying to make excel give me the day of the week a that date fell on using the WEEKDAY() function. But the day it gives me is one early, ie Monday should be Tuesday. (see attachment)
So I figure out that the ENTIRE "WEEKDAY()" function is exactly one whole day off for every single date (from 1904 right through to 2008, using iCal).
Is there anyway to fix this problem (Googling yielded no results)? I tried doing '=WEEKDAY("date") +1' which fixes the problem, only now, Sunday doesn't exist. And, I tried using a custom cell format "DDDD" with the date itself (no formulas, it'll give me the correct weekday, but other problems arise with the fact that the format in that cell is no longer a integer, but still a date format.
Any help?
Cheers,
Sam