Excel formula for comparing 2 date columns 1

[Jackmetickler]

Hello there

I wish to create a formula for the following:

I have a spreadsheet where one column gives me the date of an assistance request and another gives me the date of completion.

For stats: I wish to compare the two columns and produce a third that would say give me an output for
a; when 2 dates where the same
b: when 2 dates where different and if poss by how much although I would be happy with just showing any difference to start with.

Any assistance or pointers gratefully received
Jack

 

[xlbo]

=IF(A2=B2,"Same",B2-A2)

Where your dates are in A2 & B2

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[Jackmetickler]

Thanks for excellent and immediate reply.
Appreciate your point about FAQ's, not an excuse but I did search for answer prior to posting but as usual in this life everybody wants an answer now, so I ran out of time.

Once again
Your assistance much appreciated.
Best Regards
Jack

 

[xlbo]

no worries - the FAQs thing is just part of my auto signature - wasn't directed specifically at you

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question