Bharat1965
New Member
- Joined
- Jun 4, 2018
- Messages
- 3
Basic Pay as on 31-12-2005 | 16140 | ||||||||||
Date of 1st MACP | 1-Oct-06 | ||||||||||
Month /Year | DUE | DRAWN | Differ-ence | Bill No. & Date | |||||||
B.P. + GP | D.A. | HRA | Total | B.P. + GP | D.A. | HRA | Total | ||||
Jan-06 | 17140 | 0 | - | 17140 | 16140 | 0 | - | 16140 | 1000 | ||
Feb-06 | 17140 | 0 | - | 17140 | 16140 | 0 | - | 16140 | 1000 | ||
Mar-06 | 17140 | 0 | - | 17140 | 16140 | 0 | - | 16140 | 1000 | ||
Apr-06 | 17140 | 0 | - | 17140 | 16140 | 0 | - | 16140 | 1000 | ||
May-06 | 17140 | 0 | - | 17140 | 16140 | 0 | - | 16140 | 1000 | ||
Jun-06 | 17140 | 0 | - | 17140 | 16140 | 0 | - | 16140 | 1000 | ||
Jul-06 | 17660 | 353 | - | 18013 | 16630 | 333 | - | 16963 | 1050 | ||
Aug-06 | 17660 | 353 | - | 18013 | 17140 | 333 | - | 17473 | 540 | ||
Sep-06 | 17660 | 353 | - | 18013 | 17140 | 333 | - | 17473 | 540 | ||
Oct-06 | 17660 | 353 | - | 18013 | 17140 | 333 | - | 17473 | 540 | ||
Nov-06 | 17660 | 353 | - | 18013 | 17140 | 333 | - | 17473 | 540 | ||
Dec-06 | 17660 | 353 | - | 18013 | 17140 | 333 | - | 17473 | 540 | ||
Jan-07 | 17660 | 1060 | - | 18720 | 17140 | 1028 | - | 18168 | 552 | ||
Feb-07 | 17660 | 1060 | - | 18720 | 17140 | 1028 | - | 18168 | 552 | ||
Mar-07 | 17660 | 1060 | - | 18720 | 17140 | 1028 | - | 18168 | 552 | ||
Apr-07 | 17660 | 1060 | - | 18720 | 17140 | 1028 | - | 18168 | 552 | ||
May-07 | 17660 | 1060 | - | 18720 | 17140 | 1028 | - | 18168 | 552 | ||
Jun-07 | 17660 | 1060 | - | 18720 | 17140 | 1028 | - | 18168 | 552 | ||
Jul-07 | 18190 | 1637 | - | 19827 | 17660 | 1589 | - | 19249 | 578 |
<tbody>
</tbody>
I want to change cell value according to the change in the date of MACP.
As I change the date, 2nd coulmn change as per the any given formula.
Thanks in advance