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
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
@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
@Kaur_Manpreet - If you would like to get the day # then use the below code…
Thank you Peter. Its worked.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.