Posted to microsoft.public.excel.programming

tom

external usenet poster

Posts: 570

What a silly question !

Hi everyone,

I am facing the following situation:

A1= Monday;
A2=if(weekday(A1,2)<6,"Week","Weekend")

in A2, we should have: "Week", if the content of A1= Monday,
Tuesday,...Friday.
Or "Weekend", if the content of A1: Saturday or Sunday.

It doesn't work ! Why ?

Please help me !
Thanks very much
Tom

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Silly question	Darrell_Sarrasin via OfficeKB.com	Excel Worksheet Functions	6	May 11th 07 01:08 PM
Silly question about using dates	Zerosumgame	Excel Discussion (Misc queries)	5	April 1st 06 03:37 AM
Silly question	ksnapp[_41_]	Excel Programming	3	April 6th 04 07:59 AM
Silly Question	Mick Southam	Excel Programming	4	January 6th 04 09:32 PM
Simply silly question	paul	Excel Programming	7	August 5th 03 11:38 PM

All times are GMT +1. The time now is 07:19 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us