run different macro depending of the day of the week

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi All,

What i am trying to do is to run different macro depending of the day of the
week.
For this purpose in cell A1 i typed the formula =now() and then right
clicked on cell A1/Format Cells/Number/Category:Custom/and in the Type:
typed: dddd .
After that in cell A1 is the word Monday.
In cell B1 i type this formula: =IF(A1="Monday",1,"") BUT it looks the
formula in B1 doesn’t recognize the word Monday in cell A1 because after i
press Enter
cell B1 remains empty not 1 as it should be. I also tried to copy cell A1
and paste special as values in cell A2 and then changed the formula in B1 to
=IF(A2= 38789.66795,1,"") but the formula still doesn’t work.
Does anybody now how to do this?

Tim
 
Tim

one way:

=IF(WEEKDAY(A1)=2,1,"")

This would depend on the settings on your computer. This assumes that
Sunday is the first day of the week.

Regards

Trevor
 
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

Calculating weeks 1
copy and paste the cell with formula ="1" 3
Combining Text From Cells 3
Conditional Formatting Based on Value of Adjacent Cell 3
Name of the Day 2
simple week entry 2
Excel In Excel how can I block the contenent of a cell? 0
week entry new 3

Back
Top