How do I use the Weekday function to display "Monday" , not #

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Julie Foster - 10 Sep 2005 22:21 GMT

I am changing a Calendar view in Outlook and want to display "Monday" out ot
the Start date. I tried Weekday([Start]) but all I get is a number.
I can't find any help on how functions and formulas work.

Reply to this Message

Milly Staples [MVP - Outlook] - 11 Sep 2005 06:40 GMT

What are you using to try to create this view? Have you tried using the
standard toolbar button to show the one day view?

Signature

Milly Staples [MVP - Outlook]

Post all replies to the group to keep the discussion intact. All
unsolicited mail sent to my personal account will be deleted without
reading.

After furious head scratching, Julie Foster asked:

| I am changing a Calendar view in Outlook and want to display "Monday"
| out ot the Start date. I tried Weekday([Start]) but all I
| get is a number. I can't find any help on how functions and formulas
| work.

Reply to this Message

Julie Foster - 11 Sep 2005 16:51 GMT

I am modifying the "by Category" view using the "Define views" option. I
want to create a column showing the day of the week, ie Monday, Tuesday, etc.
Is there no help on functions and formulas that shows example of how to use
the syntax?

> What are you using to try to create this view? Have you tried using the
> standard toolbar button to show the one day view?
[quoted text clipped - 3 lines]
> | get is a number. I can't find any help on how functions and formulas
> | work.

Reply to this Message

Milly Staples [MVP - Outlook] - 11 Sep 2005 16:59 GMT

Functions and formulas do not work in Outlook. Tell us what you are trying
to do with these "functions and formulas." (Hint- they only work in Excel.)

Signature

| I am modifying the "by Category" view using the "Define views"
| option. I want to create a column showing the day of the week, ie
[quoted text clipped - 17 lines]
||| but all I get is a number. I can't find any help on how functions
||| and formulas work.

Reply to this Message

Julie Foster - 11 Sep 2005 22:07 GMT

From the Advanced Toolbar (View/Toolbar/Advanced while viewing my Calendar)
I clicked the down arrow which changes views and chose "Define Views". I
then clicked Modify (the "by category" view). Under "Fields" I clicked "New
Field". I named the field DayofWeek, chose "formula" for Type and then
clicked "Edit". A "Formula Field" pops up where I can click Field or
Function button. Does this help?

> Functions and formulas do not work in Outlook. Tell us what you are trying
> to do with these "functions and formulas." (Hint- they only work in Excel.)
[quoted text clipped - 20 lines]
> ||| but all I get is a number. I can't find any help on how functions
> ||| and formulas work.

Reply to this Message

Milly Staples [MVP - Outlook] - 11 Sep 2005 23:32 GMT

Ah, I see now. As I don't use that option (never even knew it existed!) I
will leave the answer to someone who is more experienced with customizing
views using programming, such as Sue Mosher or Diane Poremsky.

Perhaps one of them could assist you but I tend to doubt that you can add
that one to your Category view.

Signature

| From the Advanced Toolbar (View/Toolbar/Advanced while viewing my
| Calendar) I clicked the down arrow which changes views and chose
[quoted text clipped - 37 lines]
||||| but all I get is a number. I can't find any help on how functions
||||| and formulas work.

Reply to this Message

Julie Foster - 12 Sep 2005 02:41 GMT

Well perhaps the same formula in Excel would work here? I don't have Excel
on this computer so I can't look it up. Perhaps someone could let me try
their code from Excel. I would think you could hand code it if there were no
function for it but I don't know where to look for documentation for formulas
and functions in Outlook. Would it work the same as a Lotus 1-2-3 formula?
They document their formulas really well in their help.

> Ah, I see now. As I don't use that option (never even knew it existed!) I
> will leave the answer to someone who is more experienced with customizing
[quoted text clipped - 44 lines]
> ||||| but all I get is a number. I can't find any help on how functions
> ||||| and formulas work.

Reply to this Message

Milly Staples [MVP - Outlook] - 12 Sep 2005 02:58 GMT

I tend to doubt it would work as Lotus.

Signature

| Well perhaps the same formula in Excel would work here? I don't have
| Excel on this computer so I can't look it up. Perhaps someone could
[quoted text clipped - 62 lines]
||||||| but all I get is a number. I can't find any help on how
||||||| functions and formulas work.

Reply to this Message

Julie Foster - 12 Sep 2005 14:31 GMT

Well, you are right there. I tried it. Any suggestions?

> I tend to doubt it would work as Lotus.
>
[quoted text clipped - 64 lines]
> ||||||| but all I get is a number. I can't find any help on how
> ||||||| functions and formulas work.

Reply to this Message