Date period function

[algl05ab]

Hi,

I have been trying to made a simple solution on attached. I want the "period" column to automatically fill out based on the 3 categories to the right. If the the date is between "From" and "To" then choose the Period to the right.

I hope you can help.

br, Alexander

[AliGW]

Administrative Note:

Welcome to the forum.

Please update your forum profile with the version of excel that you are using.

Although we value your privacy as much you do, it could be important that members have a rough idea of your location as the solutions they offer may be affected by your locale. For instance, you might in the future post questions which are related to your regional settings.

With this in mind, please update your profile to something more precise (something such as UK, Europe, USA, UAE, etc. will suffice).

Thank you for helping us to help you.

[mehdi_154]

I assume the "ORDER_DATE" column is "From," but is there any delivery date you might need to mention? For example, if the order date is "1/1/2021," which is in column A and the order is expected to deliver on "1/30/2021" in column B, then column B - Column A = Period.

Hope that helps!

[algl05ab]

basically I'm looking for something like this:

if:

Column A i larger than D2 then period should be "1-30"
Column A i larger than D3 then period should be "31-60"
Column A i larger than D4 then period should be "60+"

[mehdi_154]

Okay, you could try using the formula below:

IF(A1>$D$2,$F$2,IF([A1>$D$3,$F$3,IF(A1>$D$4,$F$4,"")))

Let me know how it goes!

[algl05ab]

it works like a beauty. Thanks!

[mehdi_154]

Glad that I could help! But please help me to get a reputation by pressing the "Add Reputation" button, as this would inspire me to solve more problems