OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

[SOLVED] Simple Date Cell Question

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
NZRic
Newbie
Newbie


Joined: 22 Feb 2012
Posts: 4
Location: Christchurch, New Zealand

PostPosted: Wed Feb 22, 2012 4:48 pm    Post subject: [SOLVED] Simple Date Cell Question Reply with quote

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


Last edited by NZRic on Wed Feb 22, 2012 5:49 pm; edited 2 times in total
Back to top
View user's profile Send private message
ozzie
OOo Advocate
OOo Advocate


Joined: 29 Jul 2010
Posts: 400
Location: victoria

PostPosted: Wed Feb 22, 2012 5:02 pm    Post subject: Reply with quote

Code:
=DAYS360(E2;D2)


Code:
=IF(B1>0;DAYS(B1;A1);0)

_________________
If your problem has been solved please add "[Solved]" to the beginning of your first post title (edit button).
Back to top
View user's profile Send private message
NZRic
Newbie
Newbie


Joined: 22 Feb 2012
Posts: 4
Location: Christchurch, New Zealand

PostPosted: Wed Feb 22, 2012 5:08 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group