[Solved] Select week start in vertex42.com calendar

Talk about anything at all....

[Solved] Select week start in vertex42.com calendar

Postby Dafydd51 » Mon Feb 10, 2020 12:32 pm

HI,
Simple question, I'm using Vertex 42 in a spread sheet as a 2020 calendar how can I make Monday the Start of the week rather then Sunday.

Thanks,
Dave
Last edited by MrProgrammer on Fri Feb 21, 2020 7:29 pm, edited 2 times in total.
Reason: Tagged ✓ [Solved]; Changed title, was; Start of the week; Moved topic from Calc forum to General Discussion
open office 4.1.7 on macbook pro
Dafydd51
 
Posts: 1
Joined: Mon Feb 10, 2020 12:24 pm

Re: Start of the week

Postby robleyd » Mon Feb 10, 2020 12:45 pm

So, what is Vertex 42? Do you mean you have downloaded something from the website of that name - if so can you give a hint as to what it might be? Perhaps you could post the whatever here - [Forum] How to attach a document here Note maximum file size is 128K. If your file is larger, use a file sharing site such as Mediafire and post the link here.

Guessing that the function WEEKDAY might be involved; in which case see the documentation about the second argument to WEEKDAY:

Syntax
WEEKDAY(Number; Type)
Number, as a date value, is a decimal for which the weekday is to be returned.
Type determines the type of calculation. For Type=1, the weekdays are counted starting from Sunday (this is the default even when the Type parameter is missing). For Type=2, the weekdays are counted starting from Monday=1. For Type=3, the weekdays are counted starting from Monday=0.
Cheers
David
Apache OpenOffice 420m2(Build:9821) - Slackware 14.2 - 64 bit
LibreOffice 6.0.7.3 - Slackware 14.2 - 64 bit
Apache OpenOffice 4.1.4 - Windows 7 Virtual machine
User avatar
robleyd
Moderator
 
Posts: 3397
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: Start of the week

Postby DiGro » Mon Feb 10, 2020 1:11 pm

____________
DiGro

AOO 4.1.7 on Windows 10. Scanned with ZIGGO Safe Online (F-Secure)
User avatar
DiGro
 
Posts: 100
Joined: Mon Oct 08, 2007 1:31 am
Location: Hoorn NH, The Netherlands

Re: Start of the week

Postby RoryOF » Mon Feb 10, 2020 1:17 pm

The Vertex42 site says it permits starting calendars on Monday.
Apache OpenOffice 4.1.7 on Xubuntu 18.04.4 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 31239
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland


Return to General Discussion

Who is online

Users browsing this forum: No registered users and 3 guests