Am 12.06.2015 um 10:39 schrieb Michael D. Setzer II: > On 12 Jun 2015 at 8:49, Gordon Burgess-Parker wrote: > > > Date sent:Fri, 12 Jun 2015 08:49:35 +0100 > From:Gordon [email protected] > To:[email protected] > Subject:Re: [libreoffice-users] Calc date formulae > > > On 12/06/15 08:44, Dries Feys wrote: > If the date to check is in B3, try the following formula: > > > =IF(WEEKDAY(B3)=1;B3-2;IF(WEEKDAY(B3)=7;B3-1;B3)) > > > Don't forget to format the target cell as a date ;-) > >
The number format has no influence on the formula result. If the result looks wrong or ugly just change the number format to your liking. It is important to know that the cell value remains the same. -- To unsubscribe e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
