Joe
been there, done that!
Here is what I do:
Open a blank page in writer.
choose insert / fields / other . . .
on the /Variables\ tab select Insert formula.
paste:
7-WEEKDAY(NOW())+TODAY()
select a date format (from Additional format. . .)
click [Insert]
result:
** Expression is faulty **
try TODAY() or NOW() and get same result
Dave Legge
Joe Conner wrote:
You could use =7-WEEKDAY(NOW())+TODAY() . Be sure the cell is
formatted as a date.
Joe
David wrote:
In Lotus Word Pro,
I can create a field in which I can calculate the date of the next
Sunday,
and display it in the document according to a chosen date format.
viz:
now() + (6 - mod( truncate(now() / 86400) - 4 , 7))*86400 %Dd
How can I do the same in OOo ? (ver 1.1.4 or 1.9.x WinXP)
Dave Legge
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
