If more than 14 ween 2 date

[Asw091]

Hi guys,

I have a report that shows when a customer has responded with a customer service score, however it is not applicable if they’ve replied more than 2 weeks after the sent date.

Let’s say cell B is the sent date and cell C is the received date and cell F is the cell I want to show yes or no for ‘Applicable?’

How would I go about creating a formula for this?

Thanks.

 

[Joe4]

Something like:

=IF(C2-B2>14,"No","Yes")

 

[Asw091]

Something like:

=IF(C2-B2>14,"No","Yes")

Hi, thanks for the reply, but it says ‘Durations can’t be compared to other data types’. The format for the date on my spreadsheet is de/mm/yyyy

 

[Joe4]

Are the date entries in BOTH columns A and B entered as dates and not text?
That message seems to imply that at least one of them is not.

And what version of Excel are you using?

 

[Asw091]

Are the date entries in BOTH columns A and B entered as dates and not text?
That message seems to imply that at least one of them is not.

And what version of Excel are you using?

I’ve used this and it has worked as intended.

[FONT=&quot]=IF(DUR2DAYS(C2−B2)>14,"No","Yes")[/FONT]

 

[Joe4]

What exactly is "DUR2DAYS"?
It doesn't appear to be any Excel function that I have ever seen.
Is it some UDF you or someone else created?

 

[Asw091]

What exactly is "DUR2DAYS"?
It doesn't appear to be any Excel function that I have ever seen.
Is it some UDF you or someone else created?

So it appears the spreadsheet has opened in Numbers on this occasion for iPad instead of Excel. Maybe that’s why the usual formula didn’t work.

The formula was given to me by the creator who also used numbers. My bad.

 

[Joe4]

So it appears the spreadsheet has opened in Numbers on this occasion for iPad instead of Excel. Maybe that’s why the usual formula didn’t work.

I had a feeling that maybe you weren't in Excel, which is why I asked this question:

And what version of Excel are you using?

As I have never seen an Excel error message that said: "Durations can’t be compared to other data types’"