Hi,
I have a sheet that i have attached, where column a has a customer list, column b is delivery, column c is despatch.
I can get the despatch date being one day before, the delivery date, but i need to be able to write a formula that says that the despatch date should be one day before the delivery date unless the customer in column a = customer b.
Can some one help please?
Many thanks,
Allan
See attached....
allanb3048-date-changes-subject-to-customer-type-despatchdate.xlsx
What do you want it to say/do if it is customer b?
Edit*
Place this in C4 of your sheet and drag down
Please Login or Register to view this content.
Last edited by gmr4evr1; 09-20-2015 at 06:01 PM. Reason: Added formula per Ford's request
1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.
Tom
Dont know what gmr has suggested (please post your formula in your post, so members dont need to open a file), but see if this will give you wnat yo want...
=IF(A4="Customer B",B4,B4-1)
Change the bolded part to whatever you need it to be for "Customer B"
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks