Excel Checkbox in Calendar

[edwardpestian]

I have a simple excel calendar. Each cell for the month contains a Text box with the date in it. I also have a checkbox next to each date. What I would like to do is,if an employee checks a particular date, take the total number of checks in a specific two week period and return them to a cell on a separate worksheet. For example if during the period 05/28/2006 to 06/04/2006, there are 4 checkboxes check, return 4 to Cell A5.

Thanks in advance.

EP

 

[Rofeu]

Hi,

you can link checkboxes to cells through the 'linked cell' property. just link all your checkboxes to cells in a range and then do a countif for TRUE.

Cheers,

Roel

Cheers,

Roel

 

[SkipVought]

Hi,

Link each checkbox to a separate cell.

The use the COUNTIF function to count the number of checked linked references.

Skip,

_{[red]Be Advised![/red] The only distinction between a bird with one wing and a bird with two, is merely...
a difference of A Pinion!}

 

[edwardpestian]

Ultimately, I linked each check box to the calender date it represented,and changed the font color to white, so the TRUE value could not be seen. I then used a simple if statement on a separate sheet referring to the cell to count each TRUE cell as a value of one. I was then able to count all the cells with a check mark in them.

Thanks for the help.

EP