Solved

Lokking for an Excel "Day" type function.

Posted on 2011-02-16
3
401 Views
Last Modified: 2012-06-21
Hi everyone....

Does anyone know of a sort of inverse of the WEEKDAY function in Excel 2003?
If I know the day "text", I'd like to use a built-in function to change "Sun"  to 2, "Thu" to 4 etc.
I know I could use =IF(A1="Sun",1,If(A1="Mon",2,........))))))). I just wondered if anyone knew of a ready made function I could enter into the cell of a Spreadsheet (NOT a VB function).
0
Comment
Question by:sts023
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 50

Accepted Solution

by:
barry houdini earned 250 total points
ID: 34908153
No really simply way but try

=MATCH(A1,{"Sun","Mon","Tue","Wed","Thu","Fri","Sat"},0)

or

=MATCH(A1,TEXT({1,2,3,4,5,6,7},"ddd"),0)

regards, barry
0
 
LVL 50

Assisted Solution

by:barry houdini
barry houdini earned 250 total points
ID: 34908255
...if you want it to work with either Sun or Sunday in A1 change to

=MATCH(LEFT(A1,3),TEXT({1,2,3,4,5,6,7},"ddd"),0)

regards, barry

0
 

Author Comment

by:sts023
ID: 34910485
Thanks Barry - that's one up for experience (or at least, lateral thinking!).
Steve.
0

Featured Post

SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…

734 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