GirishDhruva
Active Member
- Joined
- Mar 26, 2019
- Messages
- 308
Hi Everyone,
Based on dates that are provided in column 'C' can we calculate how many days a employee had worked
Like,
<tbody>
</tbody>
I know to do this in excel with formula =+($DK$3-DAY($C6)+1), but i am trying it in VBA
Regards,
Dhruva.
Based on dates that are provided in column 'C' can we calculate how many days a employee had worked
Like,
Column C | ....... | Column DI | Column DJ | Column DK | Column DL | ....... | Column DT |
30 | 31 | 30 | 31 | 31 | |||
DATES | ...... | APRIL | MAY | JUNE | JULY | ....... | MARCH |
14-04-2019 | ....... | 17 | 0 | 0 | 0 | ....... | 0 |
04-06-2019 | ....... | 0 | 0 | 27 | 0 | ....... | 0 |
18-03-2019 | ....... | 0 | 0 | 0 | 0 | ....... | 14 |
14-01-2019 | ....... | 0 | 0 | 0 | 0 | ....... | 0 |
14-07-2019 | ....... | 0 | 0 | 0 | 18 | ....... | 0 |
<tbody>
</tbody>
I know to do this in excel with formula =+($DK$3-DAY($C6)+1), but i am trying it in VBA
Regards,
Dhruva.