Please help me with an Excel formula

Hello Everyone!   I'm trying to find a formula for the below scenario in Excel sheet.   There is an organisation where the pay is calculated on a weekly basis instead of daily or monthly.  1. Ne...