Hi All

I need a bit of help. I got a spread sheet which i'm using the NETWORKDAYS function. I'm cutting a list of dates from a worksheet and pasting another (into say column A i.e.29/06/2009 23:59:59) in the next column is the date the event actually happened(e.g. sometimes the event is on time so 29/06/2009). In column C NETWORKDAYS i want this to be zero but i understand it's not because of the time it's 1.

Any ideas how i can remove the time form col A.

Thanks