Date Picker is really great but what if I want to leave the cell blank if I do not want to pick a date????

[BecauseIcan]

So I have a date picker but what if I don't want to use it all the time.

I keep a plant Journal so I pick the date the plant was purchased then it would not have a seed propagation date(Purchased and propagation have 2 different cells)

anyway I would perfer to not have to pick a date or have it show today's day but I would rather leave the cell blank.

Can I do that?

 

[Norie]

How/when are you showing the date picker and how are you putting the picked date in the cell?

 

[Rick Rothstein]

See my complete series of responses in this thread for how to do what you asked and what you have to do account for it...

http://www.mrexcel.com/forum/excel-questions/666685-dtpicker-value-null.html