Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 287
Default 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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 04:57 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"