• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

use Calender Control for table

P

Pofski

Member
Hi everybody,

i was wondering if there was a way to achieve the following.
column A i have names, B i have Date start, and C i have Date end.
These columns are put in a table.

Is it possible to use the Calender control to fill in the cells when you select them?

I was thinking about linking the calender control to a cell (D4), and using the formula =if($d$4<>c2,if(b3="",$d$4,b3)'"") starting in b3 and going down.

But i keep running into problem.

Thank you in advance
 
Can you please rephrase your requirement. For one, if you're using =if($d$4<>c2,if(b3="",$d$4,b3)'"") in B3 and dragging down, that will cause a circular reference. So either I'm not interpreting it right, or you're not explaining it right. If you think a sample file will add more clarity, please attach one.
 
You must log in or register to reply here.
Back
Top