On Sunday May 7 2006 05:06 pm, Dennis Marks wrote:
> I have created a time sheet in a Writer document. There is a table with
> dates that are generated using a starting date. It all works fine as
> long as I don't use any functions.
>
> What I was trying to do is create a label for the second half of the
> month. It will be either 16-28, 16-29, 16-30, or 16-31 depending in the
> number of days in the month. I don't seem to be able to use any type of
> function to create this. Both logic and date functions are ignored and
> only the date within the function is displayed. Is this a bug or a
> limitation of tables?
I was able to do this in Calc but not in a Writer table. It is
possibility a limitation of tables.
This is what I did in Calc.
I set a date in the month in A1.
In B1, I entered this formula:
="16"&" - "&TEXT(DAY(A1);DAY(EOMONTH(A1;0))).
Dan
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
