[SOLVED] Simple Date Cell Question

NZRic · Last edited by NZRic on Wed Feb 22, 2012 5:49 pm; edited 2 times in total

Hi All,

First post so bear with me. I have gone back about 15 pages or so in forum list but cannot find this very simple (for all of you anyway) problem

Three Columns: Start Date, Close Date, Total Age

Simply put I am looking for the formula that says if Close Date is a date, then Subtract Close Date from Start Date and then put the result in the total age column. Now, I have done this in Excel (a lifetime ago) but I am am learning Calc.

Here is what I have:

=DAYS360(E2-D2) errors

or

=IF(B1>0;DAYS(B1-A1);0) errors

Some help would be appreciated to this very old dog learning new tricks....
_________________
Ric

ozzie · Posted: Wed Feb 22, 2012 5:02 pm Post subject:

NZRic · Posted: Wed Feb 22, 2012 5:08 pm Post subject:

Thank you very much!!! Sometimes I need those other eyes...

I can't believe I missed that solution!!! hee heee....
javascript:emoticon(' Rolling Eyes

')
javascript:emoticon(' Rolling Eyes

')
_________________
Ric