recognizing the day of the week

  • Thread starter Thread starter pls123
  • Start date Start date
P

pls123

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

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


tx !!
 
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.
 
ty rick !!





Rick Rothstein said:
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.
Click to expand...
 
you could also
=OR(TEXT(TODAY(),"ddd")="Mon",TEXT(TODAY(),"ddd")="Fri")
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

active window on top 1
if or not if ??? 1
copy a from a cell to another with desired format 7
format type in vbe 10
and, or in vbe 7
sum of absolute value of each cell of a column.. 4
insert cells 2
button for saving all workbooks 6

Back
Top