First day of the week and the calendar week
muuvmuuv
I've to do a bit calc work and need to know how I can get the first day of the current week and the calendar week. It's for my training certificate.
muuvmuuv
Thanks to @Bathsheba, @AxelRichter and more.
The function depends on which language you have set in Open Office. In my OO its german so I'll let my calculation for the first and last day of a work week here:
Monday: =DATUM(JAHR(HEUTE());MONAT(HEUTE());TAGEIMMONAT(MONAT(12)) - ( TAG(HEUTE()) - WOCHENTAG(HEUTE();2)) )
Friday: =DATUM(JAHR(HEUTE());MONAT(HEUTE());TAGEIMMONAT(MONAT(12)) - ( TAG(HEUTE()) - WOCHENTAG(HEUTE();2) - 4) )
So you just have to translate into your language. Hope this helps others too.
Collected from the Internet
Please contact [email protected] to delete if infringement.
edited at
- Prev: How to deploy Administration Area only one a different website
- Next: Cannot put text view in the right side of image in Navigation Drawer
Related
TOP Ranking
- 1
pump.io port in URL
- 2
How to import an asset in swift using Bundle.main.path() in a react-native native module
- 3
Failed to listen on localhost:8000 (reason: Cannot assign requested address)
- 4
Double spacing in rmarkdown pdf
- 5
SQL Server : need add a dot before two last character
- 6
Ambiguous use of 'init' with CFStringTransform and Swift 3
- 7
Resetting Value of <input type="time"> in Firefox
- 8
Retrieve Element Tag Value XML Using Bash
- 9
How to pass data to the ng2-bs3-modal?
- 10
JWT gives JsonWebTokenError "invalid token"
- 11
How to update azerothcore-wotlk docker container
- 12
C++ 16 bit grayscale gradient image from 2D array
- 13
redirect your computer port to url
- 14
Capybara Selenium Chrome opens About Google Chrome
- 15
mysql.connector.errors.InterfaceError: 2003: Can't connect to MySQL server on '127.0.0.1:3306' (111 Connection refused)
- 16
How to make thrown errors visible outside of a Promise?
- 17
JMeter: Why get error when try to save test plan
- 18
Should you provide dependent libraries in client jar?
- 19
Issue making model pop up onPress of flatlist
- 20
Message: element not interactable on accessing a tag python
- 21
Calling Doctrine clear() with an argument is deprecated
Comments