Using date picker for specific cell

**skhari** · 05-08-2015, 01:14 PM

Dear Experts!

Please help me in
1. getting the date in specific cell using date picker. in Cell C1
2. getting previous or next date on click of left and right arrow in Cell C1
3. Change Cell C1 bg color (Red) If Selected date is on Sundays or in list of holidays (ws Data)

Kindly refer attachment.

Thank you for your help!
-sk

**ferry2512** · 05-08-2015, 02:44 PM

Hi skhari,

Here your file and the update.

But I have any question. Why every I click on the range C5, C6, C10, there are showing your form?
I had search for that issue, but I don't know what happened.

Regards,
Ferry Mulyadi

**skhari** · 05-08-2015, 04:25 PM

Hi Ferry Mulyadi

Thank you so much for your help. Its working great.

Yes. I will get rid of that (C5) showing form issue.

--- May I ask you another help. since i am not good at coding. Can you please help me this post. very much needed.

http://www.excelforum.com/showthread...80#post4067680

Thank you so much

love
sk