Re: [users] Date calculation in a field

[Joe Conner]

I cannot tell what you are talking about. In both OOo calc 1.1.4 and 1.9.113 insert does not have a choice of "fields." My available choices are "manual break", "cells", "rows", "columns", "sheet", "sheet from file", "link to external data", special character", "hyperlink", "function", "function list", "names", "note", "picture", "movie and sound", "object", "chart", and "floating frames" but as you can see, there is no "fields." I thought you stated that you wanted a formula to cause a cell to display the date for the upcoming Sunday. Well, the formula that I gave you will do precisely that. Just use CALC to create the cell, then cut and paste it into your writer document. Attached are two files, Dave Legge Test.sxw and Dave Legge Test.odt. The OOo users group software will strip them from this email, but I am cc to your emal address and you should get the attachments just fine.  If not, let me know and I will send them directly to you off list. Joe David wrote: 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]

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]