Topics tagged month

Topic	Replies	Views	Activity
Number of Months Between two Dates: "DateDif" and "Months" Return Wrong Values? English calc , date , datedif , month	4	10909	March 6, 2024
Usage of MONTH in formula English calc , sumif , condition , month	9	4373	March 23, 2021
How to input data twice each month English calc , month , twice	2	884	February 1, 2021
Chart clustered by month English calc , group , month	3	3247	August 1, 2021
How can I extract the month, as a number, from a date field? English common , calendar , extract , month	2	2388	August 1, 2021
Immutably add days for each month in Calc English calc , month , immutable	4	1470	June 25, 2020
How to calculate time difference in years, months and days? English calc , formula , date , date-time , year , day , month	8	6697	May 11, 2020
[solved] Calc bug when using TEXT to display month in longer formula? English calc , formula , text , date , bug , month	7	2327	August 1, 2021
i want to keep the day constant but increase the month by 1 in every cell how English calc , date , increment , month	1	2618	March 18, 2020
Want EXTRACT to return a 2-digit month in concatenation English base , date , sql , extract , firebird , month	2	4144	March 6, 2020
[solved] Calc based on month(now) English calc , date , time , sum-product , month	4	1233	July 31, 2021
LibreOffice 6.0.7.3 Month(Date) Function is returning an unexpected result English calc , function , date , month	3	627	January 19, 2020
Base query - need to return data for calender month! English base , date , query , sql , range , hsqldb , hsql , month	2	2067	August 13, 2019
Increase date in month / year (mm/yyyy date formated column) by one month (mm) using AutoFill or Any simpler method English calc , column , date , year , autofill , month	6	9741	April 29, 2019
how to change gantt chart timeline to weeks/months English calc , timeline , month , gantt	0	3193	April 3, 2019
Month() in calc returns previous month English calc , month	6	3728	January 18, 2019
Calculating median using dates English calc , median , month	4	2574	July 31, 2021
Calculate a date (month and year) English calc , date , month	3	2337	July 31, 2021
Formula in Calc to show the next month English calc , next , month , windows-10 , libreoffice-534	8	6616	July 31, 2021
SUMPRODUCT + MONTH + IFERROR -> strange behaviour English calc , sum-product , month , libreoffice-54	3	1085	July 31, 2021
How to sum by year and month from external source English calc , year , sumifs , month	5	2208	July 31, 2021
Why is =MONTH("2017-01-01") showing December? English calc , format , month	4	1091	July 31, 2021
Mail Merge wildcards English writer , base , date , wildcard , partial , month , birthday	2	1345	July 31, 2021
Sorting a table in Writer with text in the form 2/12 (meaning feb 2012)? English writer , date , sort , data-table , year , month	6	1333	July 31, 2021
how to calculate age from birth day in libreoffice calc? English calc , libreoffice-35 , ubuntu-1204 , year , age , birthdate , day , month	4	22128	July 31, 2021
In Calc, how can i get the number of days in month English calc , day , month	5	11228	July 31, 2021