Michael <mmorse757 <at> gmail.com> writes: > > 3.3.1 > > I have a text document that I would like to have display a number that > represents the number of days difference between two dates. For example: > "There are XX days until Kevin retires." I would like the XX to > represent a particular date in the future minus the current date in days. > > I see how to insert the current date under the FIELDS option but I > don't see any options for manipulating that date. > > Thanks for any suggestions. > > Michael ---------
Try the DATEDIFF function in calc. DATEDIFF(<interval>,startdate,enddate) Interval is the time span you want to count (e.g., dd=days, mm=months, etc.). Calc's help files list the accepted intervals and their codes. -- Unsubscribe instructions: E-mail to [email protected] List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
