Re: [libreoffice-users] Calc date formulae

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 ;-)

Succes

Met vriendelijke groeten, Salutations distinguées, Kind Regards,

DRIES FEYS
CORPORATE SERVICES • Specialist Software Developer

TVH GROUP NV
Brabantstraat 15 • BE-8790 WAREGEM
T +32 56 43 42 11 • F +32 56 43 44 88 • www.tvh.com
Watch our company movies on www.tvh.tv


On 12 June 2015 at 09:29, Gordon Burgess-Parker <gordonbp@mail.com> wrote:
> Hi,
> I have a series of future dates calculated according to certain criteria.
> I would like to:
> 1. Add a formula in a cell that says "if this date is a Saturday, subtract
> one day, if this date is a Sunday subtract 2 days, if this date is a
> weekday, do nothing"
>
> 2. I don't know if this is even possible - could I use this future date to
> generate a reminder in Lightning calendar?
>
> Thanks
>
> --
> To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
> 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

-- 


**** DISCLAIMER ****

http://www.tvh.com/glob/en/email-disclaimer

"This message is delivered to all addressees subject to the conditions
set forth in the attached disclaimer, which is an integral part of this
message."

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
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