help with date formula please.
Thanks worked a dread
"David Biddulph" wrote:
Assuming that neither of the fields is text, and that they are Excel numbers
formatted as date and time, =INT(A2)=B2 is a suitable test.
=INT(A2) gives you date without time.
If you are starting with text, you ought to convert to Excel date & time,
then work from there.
--
David Biddulph
"julief" wrote in message
...
I am trying to compare two lots of data. Once piece of data is coming from
a
database which is holding the date field in format dd mm yyyy hh:mm. The
other piece of data is in standard ddmmyy format. I need to compare the
two
dates to make sure they are the same.
The problem i am having is that because one piece of date holds time data
also it is not showing as being the same date even though it actually is.
Can anyone please give me a formula which strips out the time element and
will then compare. I have tried to use the day() month() year () function
but with no luck.
|