IF

G

Guest

I've just been speaking to our IT helpdesk and they said my request was too
hard and would take 5 hours to work out. I'm not so sure so I'll run it past
this group.

We have to acknowledge complaints within 2 working days from receipt.

Example:

In cell D1 I type the date the complaint was received.
In cell J1 I type the date the complaint was acknowledged.
In cell K1 I type yes or no depending on whether or not the date was
acknowledged within 2 working days. Ideally I'd like excel to create the yes
or the no - but like I said, our IT desk think this is too hard.

Were they just trying to get rid of me or could some kind person tell me
what the formula would be?

Thanks
Adam
 
G

Guest

Adam,

They were trying to make you go away, 60 seconds work at worst.

=IF(J1-D1<2,"Yes","No")

Ensure the cell with this in is formatted as general.

Mike
 
G

Guest

=IF(NETWORKDAYS(D1,J1)<=2,"Yes","No")

You need the Anlaysis ToolPak: Tools=>Add-ins check Analysis ToolPak
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Comparison of columns using Conditional Formatting 3
If statements 2
Does date in Cell A1 occur between the date in M1 and Date in X1 1
Confused beginner 6
Moving rows to another sheet automaticlly 1
Excel Formatting with dates 3
If Statement 2
Conditional Formatting Traffic Light System 3

Top