I found out how to place a drop down calendar in a cell.

However, in properties section of that dropdown I reference another cell that changes to whatever date I select in the calendar. That cell can't be used in any formulas. I tried formatting it to its serial number but it won't cooperate. It seems to be text not date.

Is there a way to get it into a date format without another formula?? thanks to all.......

Maxthebear