Calculate working days

dear all

now i am faceing a problem in calucating the wrking days.
please check my attached file check the I coloum. I2= (H2-G2) but its showing error. help me to solove these problem

i like to calucate Gratuity Prvosion of staff


if staff worked 5 years their Gratuity Prvosion will be basic of 30 days.

(1-5 YRS OF SERVICE) 30 days basic salary for a year
(5-10 YRS OF SERVICE) 21 days basic salary for a year


if staff worked more than 5 years ..first 5 years will be 30 days of basic and next 2 years will 21 days basic salary. ( but i metnioned more than 5 only)

please help me to find out

thank u in advance

thank u for answer but i m getting value error in I column. so please help me to solove tat one first.

Amend your formula in col I as =(H2-G2)*1 ( and format as number of course)

Your date in col H is not a real date but text looking like date.
Each time you refer to it you can multiply it by 1 or add 0 so it will become a date again.