incubator-ooo-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From JOE CONNER <joeconner2...@gmail.com>
Subject Re: Subtraction between dates in spreadsheet
Date Fri, 24 Aug 2012 17:33:45 GMT
On 8/24/2012 09:13 AM, Ennio-Sr wrote:
> Hi all,
>
> When I opened one of my spreadsheets I found many  cells were filled
> with the '#VALUE!' warning.
> They are very old indeed (year 2008) but  they used to work fine when I
> converted them from M$ stuff with some modifications.
> As there are many trasnsactions involving subtraction between dates, I suspect that missing
> value dates may be responsible for the error: i.e. if the formula says
> '= (dateA - dateB)*n' and DateB is null, then the formula does not work.
> On the other hand, if a date is null that means that there was no
> transaction, so   I   cannot fill all void dates with a foo-value...
>
> Can you help me?
> Thanks for your attention,
>      ennio
>
Perhaps a formula similar in form to  
=IF(ISNUMBER(dateB);(dateA-dateB);dateA)

Joe Conner, Poulsbo, WA USA

---------------------------------------------------------------------
To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
For additional commands, e-mail: ooo-users-help@incubator.apache.org


Mime
View raw message