recognizing the day of the week
 

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

tx all !!
paolo

recognizing the day of the week
 

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


tx !!







"pls123" wrote:

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

tx all !!
paolo

recognizing the day of the week
 

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.

--
Rick (MVP - Excel)


"pls123" wrote in message
...
sorry again..
exactly i need a true if today it is monday , or friday..


tx !!







"pls123" wrote:

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

tx all !!
paolo

recognizing the day of the week
 

ty rick !!





"Rick Rothstein" wrote:

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.

--
Rick (MVP - Excel)


"pls123" wrote in message
...
sorry again..
exactly i need a true if today it is monday , or friday..


tx !!







"pls123" wrote:

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

tx all !!
paolo

recognizing the day of the week
 

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

"pls123" wrote in message
...
ty rick !!





"Rick Rothstein" wrote:

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.

--
Rick (MVP - Excel)


"pls123" wrote in message
...
sorry again..
exactly i need a true if today it is monday , or friday..


tx !!







"pls123" wrote:

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

tx all !!
paolo

recognizing the day of the week
 

tx!

"Patrick Molloy" wrote:

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

"pls123" wrote in message
...
ty rick !!





"Rick Rothstein" wrote:

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.

--
Rick (MVP - Excel)


"pls123" wrote in message
...
sorry again..
exactly i need a true if today it is monday , or friday..


tx !!







"pls123" wrote:

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

tx all !!
paolo