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
On 06/12/2015 07:29 AM, Gordon Burgess-Parker wrote:
could I use this future date to generate a reminder in Lightning calendar?
Lightning uses SQLite.
SQLite does no data validation. It has no objections to putting a 5 MB
binary blob into a field that is supposed to be a single integer.
The
On 12 Jun 2015 at 8:49, Gordon Burgess-Parker wrote:
Date sent:Fri, 12 Jun 2015 08:49:35 +0100
From:Gordon burgess-parkergordo...@mail.com
To:users@global.libreoffice.org
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
On 12 Jun 2015 at 8:49, Gordon Burgess-Parker wrote:
Date sent: Fri, 12 Jun 2015 08:49:35 +0100
From: Gordon Burgess-Parker gordo...@mail.com
To: users@global.libreoffice.org
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 ;-)
Succes
Great! Brilliant! Thanks very much!
--
To unsubscribe e-mail to:
=On 12 Jun 2015 at 18:39, Gordon Burgess-Parker , users wrote:
From:=Michael D. Setzer iimi...@kuentos.guam.net
To:!
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more:
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