incubator-ooo-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Scooter C <>
Subject Re: Subtraction between dates in spreadsheet
Date Fri, 24 Aug 2012 17:30:01 GMT
Good Afternoon  Ennio,

Perhaps an IF formula statement would work.

Take Care.
College Park, MD USA

Ennio-Sr wrote on 8/24/2012 12:13 PM:
> 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

To unsubscribe, e-mail:
For additional commands, e-mail:

View raw message