Today is ..

U

Uncle Sam

Dear Group

There are times in life when you ask silly questions, one
that you should know the answer and this is one of them.
Which date functions do you use to calculate the day of
the week, e.g. Monday for today’s date?

It escapes me and I have done it a million times (at
least)!

Uncle Sam
 
J

John Vinson

Dear Group

There are times in life when you ask silly questions, one
that you should know the answer and this is one of them.
Which date functions do you use to calculate the day of
the week, e.g. Monday for today’s date?

It escapes me and I have done it a million times (at
least)!
Click to expand...

DatePart("w", <date value>

returns 1 through 7 for the days of the week;

Format(<date value>, "dddd")

returns the name of the day of the week as a string.
 
Top