recognizing the day of the week

[pls123]

hi all !!
in vbe, how can i recognize the day of the week,
starting form a >now< in cell A1 ??

tx all !!
paolo

 

[pls123]

sorry again..
exactly i need a true if today it is monday , or friday..


tx !!

 

[Rick Rothstein]

You can use this to get your TRUE result...

=WEEKDAY(NOW())=2

The number use at the end of the formula corresponds to the day of the week,
so Sunday=1, Monday=2, Tuesday=3, etc.

 

[pls123]

ty rick !!

You can use this to get your TRUE result...

=WEEKDAY(NOW())=2

The number use at the end of the formula corresponds to the day of the week,
so Sunday=1, Monday=2, Tuesday=3, etc.

 

[Patrick Molloy]

you could also
=OR(TEXT(TODAY(),"ddd")="Mon",TEXT(TODAY(),"ddd")="Fri")

 

[pls123]

tx!

you could also
=OR(TEXT(TODAY(),"ddd")="Mon",TEXT(TODAY(),"ddd")="Fri")