Solved

formula for day of week

Posted on 2013-05-31
297 Views
I need to make cells change colour on certain days of the week but cannot figure out the formula.

I am trying to work on the basis 1 is Sunday, 2 is Monday etc. I only need to use Monday and Friday in my scenario.

So, in laymans terms I need to say, if today = Monday put 2 in cell C70 if its Friday put 6 otherwise put 0

I will then use the 2,6,0 to build my conditional formatting.

Hope this makes sense.
0
Question by:Jagwarman

LVL 13

Assisted Solution

Alexander Eßer [Alex140181] earned 250 total points
0

LVL 1

Accepted Solution

Teknodok earned 250 total points
Hi,
Just paste the following formula in your cell :

=IF(OR(WEEKDAY(TODAY())=2,WEEKDAY(TODAY())=6),WEEKDAY(TODAY()),0)

Regards,
Teknodok
0

Author Closing Comment

thanks
0

Featured Post

There are several quick shortcuts that can make your life easier in Microsoft Programs.  These simple tips and tricks will your work more productive and you faster at completing your tasks! MS Word (1) Creating Re-usable Scraps You can create s…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …