------------------------------
=IF(LEFT(A2,10)=("2021-10-08"),B2,"")
------------------------------
If you paste that formula into column E, you should have nulls where the
date does not match and the value in Column B where the date matches.
========================
Note the above suggestion requires column A left in TEXT format. If you
import your data as or convert it to a DATE VALUE, then "-" (equals) won't
work if you have hours/minutes/seconds included in column A (since the date
has no fractional value but unless you record something at midnight the
values in column A will all have fractional values (the HHMMSS represented
as a fractional portion of a day.) If you're dealing with DATE VALUEs You'd
need to do both a < and >= embedded in parenthesis to capture all values
within the day:
---------------------------------
IF (A2<10/8/21,IF(A2>=10/9/21,B2,""),"")
---------------------------------
I validated the first example works... I haven't validated the 2nd, but the
methodology is sound, as long as my spelling and first attempt at the
specific logic are accurate.
--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy
Context
- [libreoffice-users] SUM, SUMIF, IF, INDEX, MATCH, VLOOKUP? · Hylton Conacher (ZR1HPC)
- Re: [libreoffice-users] SUM, SUMIF, IF, INDEX, MATCH, VLOOKUP? · jean-francois
- Re: [libreoffice-users] SUM, SUMIF, IF, INDEX, MATCH, VLOOKUP? · John Kaufmann
- Re: [libreoffice-users] SUM, SUMIF, IF, INDEX, MATCH, VLOOKUP? · Michael D. Setzer II
- Re: [libreoffice-users] SUM, SUMIF, IF, INDEX, MATCH, VLOOKUP? · Michael D. Setzer II
- Re: [libreoffice-users] SUM, SUMIF, IF, INDEX, MATCH, VLOOKUP? · Remy Gauthier
- Re: [libreoffice-users] SUM, SUMIF, IF, INDEX, MATCH, VLOOKUP? · Michael D. Setzer II
- Re: [libreoffice-users] SUM, SUMIF, IF, INDEX, MATCH, VLOOKUP? · Hylton Conacher (ZR1HPC)
- Re: [libreoffice-users] SUM, SUMIF, IF, INDEX, MATCH, VLOOKUP? · Michael H
Privacy Policy |
Impressum (Legal Info) |
Copyright information: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License.
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (
MPLv2).
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our
trademark policy.