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

=B3-MOD(B3-6,7) equivalent-Solved

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


Joined: 28 Feb 2011
Posts: 1

PostPosted: Mon Feb 28, 2011 6:41 pm    Post subject: =B3-MOD(B3-6,7) equivalent-Solved Reply with quote

In cell b3 I have the actual due date of a bill. I get paid every friday. So I would like cell b4 to be the date I need to pay. So if a bill was due on March 10, then I would like it to show March 4, so when I pay my bills on friday I know what to pay.

This is the formula in excel =B3-MOD(B3-6,7). When I typed it in calc, it says "#NAME?"

any help wold be useful.


Thanks

Thanks so much that was sooooo simple.


Last edited by SIERRA07 on Mon Feb 28, 2011 6:53 pm; edited 1 time in total
Back to top
View user's profile Send private message
Sliderule
Super User
Super User


Joined: 29 May 2004
Posts: 2499
Location: 3rd Rock From The Sun

PostPosted: Mon Feb 28, 2011 6:49 pm    Post subject: Reply with quote

Use the following formula with Calc:

Code:
=B3 - MOD(B3-6; 7)


Explanation: With Calc, the SEPARATOR between function parameters is a semicolon ( ; ), not a comma as in Excel. Remember, in many places of the world, a comma is used as the decimal place. Smile

I hope this helps, please be sure to let me / us know.

Sliderule

Thanks to add [Solved] in your first post Title ( edit button ) if your issue has been fixed / resolved.
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