Thanks, My drop down menu is located in I13 and that was my "x" value in the
original question. The drop down options a 1st Sunday 2nd Sunday etc., I
tried your solution with good results, however it only works when I replace
the labels "1st Sunday" with a number. I tried adding "1st Sunday" as a NAME
in hope of using the label "1st Sunday" in the formula.

=IF(O4='1st Sunday',M4," ") doesnt work

however =IF(O4=0,M4," ") does work

although I lose my original intention in labeling the days of the week.

Thanks

"Max" wrote:

Is there a way to keep my "x" labeled as 1st sunday etc.
or do I have to change it to a number?

Sorry, I'm really not following you on the above.
Try clarifying further with sample data, expected results, etc?
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,500 Files:370 Subscribers:66
xdemechanik
---