Ask Your Question

MarcVank's profile - activity

2015-09-09 20:37:57 +0100 received badge  Famous Question (source)
2014-03-31 18:40:33 +0100 received badge  Teacher (source)
2014-03-31 18:40:33 +0100 received badge  Self-Learner (source)
2014-03-29 23:26:26 +0100 received badge  Notable Question (source)
2014-03-28 11:04:55 +0100 received badge  Popular Question (source)
2014-03-28 08:49:23 +0100 answered a question compare a date with QQ format to text

Thanks for your reply!

First i got an 501 error, but that was caused by the "," seperator. In my locale I have to use ";" as a seperator. Once that was solved it worked like a charm!

This is gonig to save me from making a messy lookup-table.

Thanks again!

2014-03-27 19:54:32 +0100 asked a question compare a date with QQ format to text

I searched a lot, but couldn't find the right solution;

specs: libreoffice Version: / Build ID: 420m0(Build:1) / Dutch / Ubuntu 13.10

In Calc I have a cell with a date value, which I format to show in which quarter it fell. Next I have to compare this value of the cell in a sum.if-function to a text-cell but I can't figure out how to compare them to get a TRUE-result.

The value of the cell is e.g. 01-01-2014, which is shown as "1ste kwartaal" (Dutch for "1st quarter") by formating this cell with a date format of "QQ". This cell, with the generated "1ste kwartaal" value, has to be compared with a cell with the text-value "1ste kwartaal" and the only outcome i get is FALSE...

Does anybody know how it's done?

cheers! Marc