Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Employee benefit period is 6/1-5/31. An employee pays 20% of our cost for
medical insurance. Since there may be 2 or 3 paychecks in a month, we divide the annual cost by 26 paychecks per year. Is there a function that recognizes 6/1, 7/1 etc so I could calculate how many months remain in the benefit year* cost of insurance * 20%? Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Match function won't recognize values unless I type them | Excel Worksheet Functions | |||
My Excel does not recognize countif function | Excel Worksheet Functions | |||
IF Function doesn't recognize TRUE | Excel Worksheet Functions | |||
When using MONTH function on Blank Cell!! Returns Month=Jan! | Excel Discussion (Misc queries) | |||
How do I get the COUNTIF criteria to recognize only month and yea. | Excel Worksheet Functions |