Hi,
In col D i have date of joning of an employee and based on the date of
joining i would like to calculate the remaining days and the number of
coupons to be given to that employee.
The amount of coupons is fixed 450. so per day it comes to 14.51
The figure will changed depending on the days in a month.

Now i want the answer in the next column by using a formula which i am not
able workout.

Any help please

--
Thanks
Suleman Peerzade