Start day of week

26 views
Skip to first unread message

Clarence Williams

unread,
Apr 8, 2014, 8:45:53 AM4/8/14
to sailfor...@googlegroups.com
Is it possible to add a starting day of week feature. Would like my weekly reports to start on Monday instead of Sunday, and I'm sure others would appreciate that feature.

Thanks for a great program

Chris

unread,
Apr 8, 2014, 12:16:05 PM4/8/14
to sailfor...@googlegroups.com
Hi Clarence:

Use the Math Command  weekDay(DATE)

It will return 1 to 7 (1=Sunday) for numbers or "Sunday" to "Saturday" for text fields.

Clarence Williams

unread,
Apr 10, 2014, 7:31:14 AM4/10/14
to sailfor...@googlegroups.com
I am using the filter "This Week", and it starts on Sunday and I can't find a way to use your formula using this filter to change starting day of week

Chris

unread,
Apr 11, 2014, 11:34:51 AM4/11/14
to sailfor...@googlegroups.com
I think the only choice is to enter the two dates.

What are you looking for? Saturday to Saturday? or Monday through Friday?

Jan-Erik Matz

unread,
Apr 12, 2014, 1:33:37 AM4/12/14
to sailfor...@googlegroups.com
Hi!
Lot countries use Monday as start of week.Causes some trouble. It is like decimal point (US) and decimal comma (EU)
I prefer week start with a Monday and end with a long weekend. :-)
Happy coding from Jemen.
Reply all
Reply to author
Forward
0 new messages