today's day number

[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

 

[Arvi Laanemets]

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

 

[Niek Otten]

=WEEKDAY(TODAY())

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

 

[Colo]

Hi, please look into WEEKDAY Function in the help.