![]() From the plugin configuration page, it is possible to duplicate a form by. Or select cell B3 and click with your mouse on the black box in the bottom right corner of cell B3, then drag down the formula up to your last row (keep the left mouse button pressed down) and then release the button. You can then make a SUM(B3:B789) to get the total of days. ![]() If your concern is to have only one formula that does all the calculation in one go, you can use =SUMPRODUCT(A3:A789-A2:A788) which will calculate (A3-A2) + (A4-A3) + (A5-A4) +. As dates are represented by numbers, the difference between two dates is equal to the subtraction of two numbers. Since the release 2.0, the Pivot Table feature has added. ![]() Other ones, like DAYS and YEARS (which calculate date differences) can be.Īnd note that the formula above can be simplified as follow: A789 - A2. Openoffice calculate days since date how to#. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |