date formula help

[Maeena]

Hi,
I have a table of employees joining date and payments for that month. The
problem is i want to calculate days from the current date till the end of the
month in order to come to total days payable.
for eg in col C (name of the emp) Col D (Date of joining) rest i need to
work this is an on going process for each month .

Any help is appreciated

 

[Suleman Peerzade]

HI,
Make sure that col D,E are formatted to date.

in the next col ie col E you need to know the number of days in that month
hence you enter this formula.
=DATE(YEAR(D3),MONTH(D3)+1,0)
Now since both the columns are formatted to date you can substract these
columns in col. F (=E2-D2) and you would get the number of days payable to
that employee. The date of joining will not be added to this in case if you
wish to add the date of joining please put the formula = E2-D2+1
This should solve you issue
--
_______________________
Click "Yes" button if it helps
________
Thanks
Suleman Peerzade