How to create the reverse of the TEXT function to find a day in the week

[tmd63]

The function =TEXT(A30,"dddd") will place the text of the day of the week dependent of the cell value. 1 = "Sunday", 2 = "Monday" etc.
But (apart from using multiple iff else statements), is there a reverse of this that will provide a value dependent on the text of the day. IE "Sunday" = 1, "Monday" = 2, etc. This is similar to the WEEKDAY() function but without the months or years being specified.

 

[barry houdini]

With the text day in A1 try this formula

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

 

[Tetra201]

Or this:

=SEARCH(LEFT(A1,2),"_SuMoTuWeThFrSa")/2