Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is weekday?
Hi! I have a small problem. In my Excel macro I want to check if a certain
date that exists in an array is a weekday (Saturday or Sunday). My excel-version is in Swedish so I do not know how to do this in my VBA macro. In Excel there is a function (in Swedish) that is like this =DATE(a1). It returns a number depending on what day is entered in cell a1. That is what I want to do in my macro. Please help me! Many thanks in advance! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is weekday?
=WEEKDAY(A1) returns a number 1 to 7 indicating what day it is. Sun = 1, Mon = 2, Wed = 3 etc -- Special-K ------------------------------------------------------------------------ Special-K's Profile: http://www.excelforum.com/member.php...fo&userid=7470 View this thread: http://www.excelforum.com/showthread...hreadid=572148 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is weekday?
=VECKODAG(A1;2)5
shows TRUE if Sat or Sun -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Arne Hegefors" wrote in message ... Hi! I have a small problem. In my Excel macro I want to check if a certain date that exists in an array is a weekday (Saturday or Sunday). My excel-version is in Swedish so I do not know how to do this in my VBA macro. In Excel there is a function (in Swedish) that is like this =DATE("a1"). It returns a number depending on what day is entered in cell a1. That is what I want to do in my macro. Please help me! Many thanks in advance! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
WEEKDAY() function: display TEXT not numeric weekday | Excel Discussion (Misc queries) | |||
Weekday | Excel Worksheet Functions | |||
Weekday | Excel Discussion (Misc queries) | |||
Weekday | Excel Worksheet Functions | |||
WEEKDAY using IF | Excel Discussion (Misc queries) |