And you can tell the difference between a 'text' date and a 'date value' date by turning on "value highlighting" menu-->View-->Value Highlighting
Blue is a value or date value, Green is a formula, Black (or the regularly formatted color if you've painted your spreadsheet) is text. On Sun, Dec 19, 2021 at 11:49 AM Michael H <[email protected]> wrote: > and my 1st attempt at logic is horribly flawed for the DATE VALUE cells: > > <, >= should be > > --------------------- > Greater/less than option > =IF(A2>=DATE(21,10,8),IF(A2<DATE(21,10,8)+1,B2,""),"") > ============ > (I haven't been able to make the absolute value option work. ) > > > On Sun, Dec 19, 2021 at 11:26 AM Michael H <[email protected]> wrote: > >> I've never tried it, but the ABS function on the Date Cell might also >> work. >> ------------------------------------ >> IF (ABS(A2)=10/8/21,B2,"") >> ------------------------------------ >> > -- To unsubscribe e-mail to: [email protected] 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
