Hi, I have a list of dates, that go from =TODAY() and then +7 until
October time. (So one entry a week based on todays date). I then have
created a combo box based on these dates and that works fine. I have
done a cell link to another cell, so I can use the date in some
conditional formatting, but the cell link just displays the position
in the combo box. Therefore my first date, is 01-01-1900 if I set
that field as date format or 1 if anything else. I have tried
changing the original input date to be Text. (i.e from original row of
date, =TXT(A1,"dd-mm-yyyy") and then referenced the text field as a
combo box, but still I just got the position in the combo box. Can
anyone help me get the correct date selected from the combo box into a
cell? Cheers, Rich