If I have the days of the month in Cell F2 is it possible to have excel divide that time into two separate payroll dates? For example: could excel auto populate E6 with day one (1/1/15) and F6 with last day of payroll (either 15th or last day of month)?

thank you