Calc date formulae

users
#1

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

#2

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 :wink:

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

#3

Great! Brilliant! Thanks very much!

#4

Date sent:Fri, 12 Jun 2015 08:49:35 +0100

#5

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.

#6

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 Lightning database has a number of tables, most of which are fairly
complex.

Consequently, you would have to verify that the data being exported to
the Lightning database, is both of the correct data type, and within the
parameters that Lightning can handle.

If you have the programming savvy, you could write a macro/extension
that exports the appropriate data in the spreadsheet, to Lightning.

I'm not aware of anything for Firefox/Thunderbird/Sunbird or
LibO/AOo/EU/NO that can read ODF spreadsheets and write to a Lightning
Calendar.

jonathon

#7

Date sent: Fri, 12 Jun 2015 08:49:35 +0100