Libreoffice version 7.0
Hi there,
I’m using this formula to check for the number of days an invoice has been due: =IF(TODAY()>A7,TODAY()-A7, "")
A7 is where the date is entered. O7 is where the above formula is entered and the number of days are displayed.
The formula works fine. However when A7 is blank, I get a number such as 44195 or 44198 in O7.
How do I get O7 to be blank when there is no date in A7? I’'ve tried adding the ""
in the formula it does not seem to work.
The Column O also contains conditional formatting with styles, basically colors, for when the number of days exceeds a limit. Not sure if that is relevant.