Solved

formula for day of week

Posted on 2013-05-31
3
297 Views
Last Modified: 2013-05-31
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
Comment
Question by:Jagwarman
3 Comments
 
LVL 13

Assisted Solution

by:Alexander Eßer [Alex140181]
Alexander Eßer [Alex140181] earned 250 total points
Comment Utility
0
 
LVL 1

Accepted Solution

by:
Teknodok earned 250 total points
Comment Utility
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

by:Jagwarman
Comment Utility
thanks
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Article by: dandraka
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 …

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now