How to identify week day for a date?

Help IT Automation
1

I need to find a weekday for a date.
example:-
Date= (08/03/2021) then return value should be Tuesday/3(0-7).

0 will be Sunday
1 will be Monday so on

2

@Kaur_Manpreet
Welcome to the forum

We can use
CDate(“08/03/2021”).DayOfWeek

it will return 2 As by following
SUN=0
MON=1
…
SAT=6
So we can correct

Another option could be a customized lookup dict/array

3

@Kaur_Manpreet - If you would like to get the day # then use the below code…

image

4

Thank you Peter. Its worked.

5

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.