Hi,
I would like to know How I can compare the two dates below.
Date1: 21/08/2014 17:05:01
Date2: 22/08/2014 10:20:52
I try to use NETWORKDAYS(Date1,Date2) but I do not have the good result.
I also try to do Date2-Date1. I do not realy have the good result because the result contain the weekend days and I need only the workdays.
Do you have an idea how I can do this in vba?
Thank you.
I would like to know How I can compare the two dates below.
Date1: 21/08/2014 17:05:01
Date2: 22/08/2014 10:20:52
I try to use NETWORKDAYS(Date1,Date2) but I do not have the good result.
I also try to do Date2-Date1. I do not realy have the good result because the result contain the weekend days and I need only the workdays.
Do you have an idea how I can do this in vba?
Thank you.