Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Calculating first day of the month

1 view
Skip to first unread message

Matt Riggsby

unread,
Sep 11, 1997, 3:00:00 AM9/11/97
to

Is there a mathematical formula whereby, given the month and the year,
one can determine what day of the week a month begins on? And can it be
expressed as a conglomerationg of @formulas?

Stosh

unread,
Sep 12, 1997, 3:00:00 AM9/12/97
to

@Weekday(@Date(year;month;1))

will return a numeric value of the weekday, where Sunday=1. I'll
leave up to you to put in the @If statements to create the text
version of the weekday, such as:

@If(@Weekday(@Date(1998;1;1))=1,"Sunday",@If @Weekday
(@Date(1998;1;1))=2,"Monday",@If ......

Stosh

On Thu, 11 Sep 1997 12:05:39 -0700, Matt Riggsby <mrig...@sybex.com>
wrote:

0 new messages