n M1 a date is entered in the 02-Sep-05 format
in range P13:P15 I have day cost fees, [ P13 1.50], [ P14 2.00], [P15
2.50]
In P4 the formula {=TEXT(M1,"ddd")} which denotes 2nd. Sep as Wed,
3rd.Sep as Thu, 4th. Sep as Wed
Now in P5 I want to enter a fee relevant to the day name

Displayed in P4 would be if P4 = Fri then day cost = $1.50 , if P4=Thu then
day cost = $2.00, if P4= Wed then day cost = $2.50
Hope this is explains it