[libreoffice-users] Re: Date functions

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 users+help@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***