William Case wrote:
Hi;
Just double checking that I have things in some date formulae written
correctly.
OOo starts dating at 30/12/1899 shows as Dec 29, 1899 when MMM DD, YYYY
formatting is applied. It appears to lose a day. The 30/12/1899 date
none-the-less is the date that is used for internal date arithmetic, is
it not?
Put a zero into the formatted cell. It shows 1988-12-30.
Check the value (Format 0.000000000)
Your function may need =ROUND(<your formula>;0)
In Help the WEEKS() Function is defined as follows:
WEEKS(Start date, End date, Type)
Calculates the difference in weeks between two dates.
Start date: First date
End date: Second date
Type: Calculates the type of difference. The possible values are 0
(interval) and 1 (in numbers of weeks).
If the Start date is set to 30/12/1899 and End date is today, WEEKS()
returns 5562 weeks for Type value 0 and 5563 for Type value 1.
Help is not clear, on the difference between interval type (0) and 'in
number of weeks' type (1).
I have never used that function. I use =(end-start)/7 with round(),
roundup() or rounddown().
What I really want to do is count the number
of Mondays since the 30/12/1899 start date. I think this means I want
to use Type 2 but I would like to have this assumption confirmed, if
someone could take the time to help.
Not exactly, but I could copy and paste.
First day of week for some month:
=DATE(myYear;MyMonth;1)+MOD(myDoW-WEEKDAY(DATE(myYear;MyMonth;1));7)
where myYear and myMonth specify the month in question and myDoW is a
day-of-week-number as returned by WEEKDAY(Date). Sun=1,...Sat=7.
Same with last day of week for some month:
=DATE(myYear;MyMonth+1;0)-MOD(WEEKDAY(DATE(myYear;MyMonth+1;0))-myDoW;7)
Test with some named style having a date-format like YYYY-MM-DD NN
(2006-06-02 Fr)
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
