Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Checkbox and Calendar
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. The month is in a cell above each month. Thanks in advance. EP -- edwardpestian ------------------------------------------------------------------------ edwardpestian's Profile: http://www.excelforum.com/member.php...o&userid=33809 View this thread: http://www.excelforum.com/showthread...hreadid=548844 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Checkbox and Calendar
Counting the number of checkbox ticked is straightforward but how do you
intend to specify the two week period? Input a range or highlight a group of cells.... or..... -- Cheers Nigel "edwardpestian" wrote in message news:edwardpestian.28yp1a_1149565806.2964@excelfor um-nospam.com... 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. The month is in a cell above each month. Thanks in advance. EP -- edwardpestian ------------------------------------------------------------------------ edwardpestian's Profile: http://www.excelforum.com/member.php...o&userid=33809 View this thread: http://www.excelforum.com/showthread...hreadid=548844 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i export excel calendar info to outlook calendar? | Excel Discussion (Misc queries) | |||
excel calendar - list of names displayed on calendar | Excel Worksheet Functions | |||
How do I link one checkbox to update another checkbox? | Excel Programming | |||
checkbox on form reset from checkbox on sheet | Excel Programming | |||
import calendar items from excel into outlook calendar | Excel Discussion (Misc queries) |