S
Shirley Munro
Hi
I am having problems subtracting dates. Ideally I would like to us
the NETWORKDAYS function but the problem I am having is that the fil
is imported from Oracle and some of the dates include both the date an
actual time, for example, 02/01/06 14:20:44. There are 2 spaces betwee
the date and the time. I have tried a combination of the LEFT and LE
functions to remove the time but because this is a text function, i
converts all the dates to text. You then need to convert them back t
numbers and apply a date format. I am hoping someone can come up wit
a quick way of changing a date such as 14/06/06 15:23:24, to 14/06/0
so that this is the actual value that shows in the Formula Bar.
Thanks
Shirley Munr
I am having problems subtracting dates. Ideally I would like to us
the NETWORKDAYS function but the problem I am having is that the fil
is imported from Oracle and some of the dates include both the date an
actual time, for example, 02/01/06 14:20:44. There are 2 spaces betwee
the date and the time. I have tried a combination of the LEFT and LE
functions to remove the time but because this is a text function, i
converts all the dates to text. You then need to convert them back t
numbers and apply a date format. I am hoping someone can come up wit
a quick way of changing a date such as 14/06/06 15:23:24, to 14/06/0
so that this is the actual value that shows in the Formula Bar.
Thanks
Shirley Munr