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]
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.323 / Virus Database: 267.8.10/43 - Release Date: 7/6/2005
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
