| View previous topic :: View next topic |
| Author |
Message |
SIERRA07
Newbie
Joined: 28 Feb 2011
Posts: 1
|
 Posted: Mon Feb 28, 2011 6:41 pm Post subject: =B3-MOD(B3-6,7) equivalent-Solved |
 |
|
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 |
|
 |
Sliderule
Super User
Joined: 29 May 2004
Posts: 2477
Location: 3rd Rock From The Sun
|
| Posted: Mon Feb 28, 2011 6:49 pm Post subject: |
|
|
Use the following formula with Calc:
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. 
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 |
|
|
|
|
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
|
