today's day number

  • Thread starter Thread starter M K W
  • Start date Start date
M

M K W

Hello,
I just want to know the function (if any) that returns the day number of
today, for example, if today is Monday I want to get 1 and for Sunday 7 (or
what any default for excel) I dont care for the value of the number but I
want a number between 1 and 7.
any help would be highly appreciated
thank you
 
Hi

=WEEKDAY(A1)
or
=WEEKDAY(A1,1)
returns the number of weekday with Sunday=1 ... Saturday=7

=WEEKDAY(A1,2)
returns the number of weekday with Monday=1 ... Sunday=7

=WEEKDAY(A1,3)
returns the number of weekday with Monday=0 ... Sunday=6
 
Back
Top