javakit1969
asked on
Excel Date Question
Hi Experts ,
sorry for my bad English
We need to calculate date Annual Leave and numbers of days.
and automated to Cells H3.
It anyway to improve our macro ,
so that it will show on Col H numbers of day.
Attached the file below
Hope experts can help us to resolve the problems.
Thanks
Javakit
AL-sample.xlsx
sorry for my bad English
We need to calculate date Annual Leave and numbers of days.
and automated to Cells H3.
It anyway to improve our macro ,
so that it will show on Col H numbers of day.
Attached the file below
Hope experts can help us to resolve the problems.
Thanks
Javakit
AL-sample.xlsx
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi all,
thanks for helping.
we have solve the problem by using function DATEIF.
Thanks and regards
Javakit
thanks for helping.
we have solve the problem by using function DATEIF.
Thanks and regards
Javakit
ASKER
resolve by using DATEIF
Pleased to help
ASKER
it can't show any result.
Thanks.