I am in the process of putting together an excel spreadsheet. I would like to automaticly have excel calculate the # of payrolls between biweekly payroll dates specifcly related to cross years.
For instance, we have 21 payrolls from 9/9/2014 - 6/30/2015, I would like the formula to return 21 payrolls. Also, if I change the date to reflect the next payroll 9/18/2014 - 6/30/2015, I woudl like the formula to return 20 payroll dates. . I would like to create a formula to count the number of payrolls. What formula should I be using?
Thanks
For instance, we have 21 payrolls from 9/9/2014 - 6/30/2015, I would like the formula to return 21 payrolls. Also, if I change the date to reflect the next payroll 9/18/2014 - 6/30/2015, I woudl like the formula to return 20 payroll dates. . I would like to create a formula to count the number of payrolls. What formula should I be using?
Thanks