It has been a while since this question was asked so my attempt at a solution may not be needed now; I needed to solve the same problem. I couldn't find a function that would do it so I wrote an 'if' function which is below:
=IF(MOD(B4,7)=0,"Sat",IF(MOD(B4,7)=1,"Sun",IF(MOD(B4,7)=2,"Mon",IF(MOD(B4,7)=3,"Tue",IF(MOD(B4,7)=4,"Wed",IF(MOD(B4,7)=5,"Thu",IF(MOD(B4,7)=6,"Fri",10)))))))
The 'if' function is a copy from my spreadsheet so it should work for you.
The reference 'B4' in the above function refers to the cell where the function can find the date to calculate its result.
You can alter the result format to whatever you desire; short names suit my spreadsheet.
You may want to look at this post -> How do I derive a text day (Monday, Tuesday,...) from a date field (7/21/2016)
In a cell enter -> =now() <- that will give today's date. Then in that cell, format that cell (ctrl + 1) to return just the day, rather than day, month, year.
Asked: 2015-10-10 00:35:05 +0100
Seen: 553 times
Last updated: Aug 20
Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.
LibreOffice version 5.0.2.2 OS version Windows 10 Detailed steps taken: Installed LO, installed offline help.