LibreOffice Calc - Custom Date formats

[@ThatUltimateFlash]

Thanks man, the first 30 seconds of this video was all I needed.

[@veganath]

Thanks great info, may I suggest you use a date where the Month & Day are easily distinguished e.g. 12/25/15 where it is obvious which is the day & which is the month as opposed to 2/2/15.

[@sajidkalamthodi7290]

Excellent

[@schylerosborne9803]

I need to be able to see formats 12/10/18 AND 12/11-14/18. But typing in MM/DD-DD/YY, MM/DD/YY does not recognize the latter (single dates). What should I do to get both formats recognized in the same column?

[@vasilisnikitaras]

Amazing!!

[@Thiago-rr5kz]

hello, how to insert macro code for automatic conversion to hh:mm?

[@shawnkovac1042]

does anyone know how to show the date ordinal text, like if i want it to show 'January 21st' or 'January 22nd' or 'January 23rd' or 'January 24th'? I got the 'MMM D' part. but i don't know how to show that 'st' or 'nd' or 'rd' or 'th'. (shrug) I am simply not impressed (at all) with how LibreOffice chose their date/time format codes. :(

[@Thiago-rr5kz]

hi see error 0,:25 - correct 06:00 - how to fix?

[@minalthakur3725]

i getting hashs