Re: #VALUE! Error

2022-08-28 Thread David Robley
I think you have LibreOffice, as Apache OpenOffice is only at version 4.1.13. There may be differences between the two programs that could in some cases make a difference to the answers to questions; please make sure you are clear about what software you are using. On 29/8/22 00:19, Vince@Veri

Re: #VALUE! Error-- SOLUTION Found

2022-08-28 Thread Brian Barker
At 13:53 28/08/2022 -0400, Vince Bonly wrote: I now know why and how to correct this error. I found that when entering the starting date in cell A4, if I initially enter 02/23/2022, rather than 23 February 2022, the result in cell H4 is correct; e.g., 186. So your new typing has been interpre

Re: #VALUE! Error-- SOLUTION Found

2022-08-28 Thread Vince@Verizon
On 8/28/2022 10:49 AM, Vince@Verizon wrote: {{{ snipped }}} I don't know why I am getting a #VALUE! error in cell [H4]. Probably something simple... but it escapes me How can this be corrected? {{{ snipped }}} I now know why and how to correct this error. I found that when entering

Re: #VALUE! Error

2022-08-28 Thread Vince@Verizon
On 8/28/2022 10:49 AM, Vince@Verizon wrote: [snipped] Cells A4 and B4 are formatted as Date, D, . Misspoke; meant to write: DD [snipped] The calculated results in those cells are: 23 February 2022            28 August 28 2022            #VALUE! Another of my errors. Sho

Re: #VALUE! Error

2022-08-28 Thread Brian Barker
At 10:49 28/08/2022 -0400, Vince Bonly wrote: I have a vers: 7.3.2.2 Calc sheet on my Win10x64 Home, build 19043, desktop with labels for columns A, B and H as follows: [A] ... [B] ... [H] Delivery Date ... Today Is ... Days Since Delivery The data within cells A4, B4 and H4 are as follows: 23

#VALUE! Error

2022-08-28 Thread Vince@Verizon
Hi: Hope all is well with you and yours. I have a vers: 7.3.2.2 Calc sheet on my Win10x64 Home, build 19043, desktop with labels for columns A, B and H as follows: [A]                              [B]               [H] Delivery Date                  Today Is    Days Since Delivery The