Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |