Hello: Thank you for responding. How can I input a formula on the date from the beginning of the pay period to the end. Then it starts again on the day of the beginning of the pay period. Please ignore the date on the excel now. I was trying to play with it but I'm not going any where with the formula. So 2/16/2016 starts on Tuesday then 2/29/2016 ends on Monday. However with the rest of the days it will just be blank.
I don't think my excel is in merged cells?
|