Write the sentence “This is my first sentence”. We typed “1st, 2nd and 3rd” into cells A1, B1 and C1. Open a new Calc document and fill in some data. In this example, we will create a sentence in OpenOffice Calc and insert one of the words as a reference from another cell. We will cover the process of inserting simple formulas that point to another cell, explore random sentence generation methods and word replacement within sentences. You may use either Microsoft Excel or OpenOffice Calc for this purpose.

If you want to calculate the number of days between two dates, use the DATEDIF function with interval 'd'.In this tutorial we will show you how to program simple sentences which contain formulas. Number of whole days when subtracting years from the difference of Start date and End date.Įxamples Number of days between two dates Number of whole days when subtracting years and months from the difference of Start date and End date. Number of whole months when subtracting years from the difference of Start date and End date. Number of whole years between Start date and End date. Number of whole months between Start date and End date. Number of whole days between Start date and End date.

Interval is a string and accepted values are below.

Start date and End date are the date range for your calculation.

Syntax =DATEDIF(Start date End date Interval) This function returns the number of whole days, months, years between two given start and end dates. Its always better to use a function to calculate the date difference. Having trouble with date calculations in LibreOffice Calc? In this guide, you will learn how to calculate the types of date difference in LibreOffice Calc.

Openoffice excel recalculate