How to use date functions in LibreOffice calc

This is a LibreOffice Calc tutorial covering how to use date functions. The tutor starts off by going through several date functions in LibreOffice Calc. Each function is demonstrated using several date options. This is a LibreOffice Calc tutorial. Date functions in Calc. How to use date functions in LibreOffice calc.
#calc
#libreoffice
If you want to support me, check this out: / itseasy
Classroom based courses can be arranged at www.itseasy.co.uk/
Courses are available through Microsoft Teams, Online and Face to face in the UK
Online courses at itseasytraining.teachable.com/
Udemy Courses www.udemy.com/user/stephen-sa...
Training Guide Books
Excel for New Managers
www.amazon.co.uk/Excel-New-Ma...
Microsoft Project Overview www.amazon.co.uk/Microsoft-Pr...
Microsoft Visio Basic www.amazon.co.uk/Microsoft-Vi...
Very cheap E_books are here:
Excel For New Managers payhip.com/b/IE4x
Microsoft Project Overview payhip.com/b/wY0m
Microsoft Visio Basics payhip.com/b/5XeV
Microsoft Access Introduction payhip.com/b/ynSL
A PowerPoint Overview payhip.com/b/YkQv

[@EasyMicrosoftWord]

Love it

[@libreofficetutorials9499]

thanks

[@andre.79]

Awesome! Thanks a lot!

[@libreofficetutorials9499]

No worries!

[@EasyMSAccess]

love it

[@libreofficetutorials9499]

thanks

[@ITsEasyTraining1st]

Super cool

[@libreofficetutorials9499]

thanks

[@grannysaxton9568]

Nice and easy

[@libreofficetutorials9499]

Thanks a lot 😊

[@christopherlyons7613]

I have date/time values that I want to add a number of minutes & seconds to and get the resulting date/time value. Is there a date function that would allow you to do this? For example, I have a starting date/time value of "04/08/2024 14:53:11" and I need to add a min:sec duration of "12:58". I need the result formatted as a date/time value. How can I do this?

[@libreofficetutorials9499]

Yes you can, format the date time as date time use ctrl +1 to get into format cells. then format the second cell as time. Add the two together it will work and add the time on to the first date and time cell.

[@ITX-EcoClass]

I can't seem to get the =MONTH() function to properly copy to my other cells. It's fine if I enter it manually, but I can't drag it down the row and have it give an accurate sum, it only shows the result of the cell that was copied. Annoying, but thank you for this video, because unless you're comfortable with coded language speak then the help manual is really... useless.
EDIT: And I figured it out - my cells were formatted as DATE, when they should've been set to General.

[@Albertbullterrier]

Sometimes these things are sent to try us. It should copy down, probably a bug

[@libreofficetutorials9499]

It should pull down, try reloadedor updating

[@mrfudd13]

Is there a function which gives a DATE, a number of DAYS after a start DATE?

[@libreofficetutorials9499]

Use the days function

[@mrfudd13]

@@libreofficetutorials9499 Actually, I was overthinking it: all you have to do is put a date in, it can be "3/5/24" or "March 5" and then add "+ n", and Calc. will figure it out: no function needed.

[@AccessTanya]

Love it

[@libreofficetutorials9499]

thanks