Hi excellent people, just trying to create a template that calculates specific days for delivery. so when you enter in the target amount of days ie: 3 days it gives you the date for 3 days but also if you go over the amount of days and the window of delivery has been exceeded, the template to flag the error. hope that makes sense..
Pho3nix
Basically - yes, it makes sense. But to give you more useful answer we need to know the layout of your data. See yellow banner near the top of the page.
Best Regards,
Kaper
have edited this version to show a rough idea for what i'm after. thank you
Last edited by Pho3nix; 05-03-2020 at 05:16 AM. Reason: adding attachment
I think you may have misunderstood the nature of these forums. The free help you get here is in the form of guidance and advice - we don't build whole solutions for you to a brief.
Please mock up manually the sort of thing you want and attach the workbook here, and we can take it from there.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
The general answer then:
Dates in excel are just consequtive numbers, so if you use
Formula:
Please Login or Register to view this content.
you will get date three days from today.
May be it's worth also to see theFormula:Please Login or Register to view this content.
As for flags: probably you could use conditional formatting with the rule based on formula. There are many examples of such approach on the forum (and elsewhere).
sorry i did misunderstand, i have the above attachment but i'm not sure if this will work for what i wanted. I'm just after a formula that will calculate days and exceeding days
this helps a lot! thank you
Thank you for the attachment. Where are you going to enter target days? And what flagging do you want to see? Mock these up MANUALLY and post the workbook again.
Just edited my previous attachment showing the desired effect i'm after... if it's possible?? thanks for your time.
We are getting somewhere, however your red mock-ups do not all seem to tally.
Anyway, here is the rule for the red cells:
=AND(F$5>$D7,F$5<=$C7+$E7-1)
Last edited by AliGW; 05-03-2020 at 05:40 AM.
that's exactly what i'm after!! Thank you so much Ali
No worries!
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
it certainly does, just marked solved. Thanks again!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks