How Can put next day target on excel sheet

Hello All,

I looking for someone who help me to fix the target on excel sheet with the help of formula

Example : 30 days in a month
Every day target is 50 CPH (CASE PER HOUR) in 10 login hrs in a month and 50 CPH average in month so my excel sheet will tell me the next day target according to 50 cph and pending month target