[Solved] Formula for dates

Discuss the spreadsheet application

[Solved] Formula for dates

Postby Imtom.113 » Wed Feb 13, 2019 3:05 am

Hi all... first post. I did look thru posts, but did not see an answer that applied exactly. I am building an equipment depreciation schedule. I need a formula that will calculate the number of months (as an integer) between a variable purchase date and a fixed end date. Any assistance on this would be greatly appreciated... THx, Tom
Last edited by Imtom.113 on Sun Feb 17, 2019 6:44 am, edited 1 time in total.
OpenOffice 4.1.6 on Windows 10
Imtom.113
 
Posts: 3
Joined: Wed Feb 13, 2019 2:06 am

Re: Formula for dates

Postby Villeroy » Wed Feb 13, 2019 3:10 am

MONTHS is the name of the function.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, OpenOffice 4.x & LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 26411
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Formula for dates

Postby robleyd » Wed Feb 13, 2019 3:12 am

The Help - F1 - is also a good resource; search it for month.
Cheers
David
Apache OpenOffice 4.2.0 Build 9820 alpha version - Slackware 14.2 - 64 bit
LibreOffice 6.0.7.3 - Slackware 14.2 - 64 bit
Apache OpenOffice 4.1.4 - Windows 7 Virtual machine
User avatar
robleyd
Moderator
 
Posts: 2521
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: Formula for dates [SOLVED]

Postby Imtom.113 » Sun Feb 17, 2019 2:35 am

I keep trying to post that my question was solved, but not having any luck? What am I doing wrong ?
OpenOffice 4.1.6 on Windows 10
Imtom.113
 
Posts: 3
Joined: Wed Feb 13, 2019 2:06 am

Re: Formula for dates

Postby robleyd » Sun Feb 17, 2019 2:50 am

How to tag a topic as solved.

In your first post, click the Edit button. Go to the subject line and add [Solved] at the beginning of the subject.

Then select the green tick as the Post icon (just below the subject line). Preview if you wish to see how it looks.
Finally, hit Submit - done!
Cheers
David
Apache OpenOffice 4.2.0 Build 9820 alpha version - Slackware 14.2 - 64 bit
LibreOffice 6.0.7.3 - Slackware 14.2 - 64 bit
Apache OpenOffice 4.1.4 - Windows 7 Virtual machine
User avatar
robleyd
Moderator
 
Posts: 2521
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia


Return to Calc

Who is online

Users browsing this forum: No registered users and 43 guests