Yes, the fact that we can use Mod to determine the day of the week is specific to Calc (Excel), since the date uses the serial number of the day. This is not always the case, for example in databases.
and we should keep in mind that the user could also change the base date, which will break the raw MOD operations on dates
1 Like
… except we regard the offset like in =MOD(Date-Offset-1;7)+1
I hope so. In principle dates actually are stored in Calc files like they are communicated: in ISO 8601 extended. The displayed format is stored in addition.
That (ISO…) is the definite format: Only this format is standardized by the entrusted institution, is easily readable by both human and machine, and also says quite clearly “I am a date”.
(The ‘nulldate’ hokum only comes around the corner when the persistent format is converted to DoubleFloat for the “living” sheet. Concerning the weekday question we only need to know the weekday result for any fix date in what way ever given unambiguously as long as every week has 7 days.)
The remaining ambiguity concerning the time zone is due to facts we can’t easily change. Where absolute unambiguity is indispensable we can use UTC time and date, and apply zone offsets as needed.
This is not quite serious. But there are cases now and then where we don’t find a way out of a jungle we stepped in - and one way to get a counter result even in the jungle is to simply count.
disask86374NoDoubtLeft_TheyAreCounted.ods (20.1 KB)
1 Like