IF
 

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

IF
 

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

"Adam" wrote:

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

IF
 

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

You need the Anlaysis ToolPak: Tools=Add-ins check Analysis ToolPak
"Adam" wrote:

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

IF
 

Oops missed OP said workdays!!

"Toppers" wrote:

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

You need the Anlaysis ToolPak: Tools=Add-ins check Analysis ToolPak
"Adam" wrote:

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