Formula for IF THEN Date

KaraMarv

Hi all,

I am trying to write a formula for an IF THEN situation but I am stuck. I need to make a formula to show a value per month only within the start date and end date. For example, below is a picture of a row on the sheet I'm working on. I need to create a formula below each month that would show the monthly production rate only if the product is within the start and end date. For example, Nov, Dec and Jan would have the monthly production rate of the price shown for this one project below but that price wouldn't show for Feb because it's not within the date range. (see first photo). But we want it to look like the second photo where it populates for the date range it is within and then shows $0 if it doesn't fall within that range.

(Currently looks like)

(Wants it to look like)

I hope that makes sense. If you need anything clarified, please let me know. Any help is much appreciated.

Thank you!

Paul Newcome

You will need to adjust the formula for each column, but the basic idea is

=IF(AND([End Date]@row >= DATE(2024, 11, 1), [Start Date]@row < DATE(2024, 12, 1)), [Monthly Production Rate]@row, 0)

KaraMarv

That worked perfectly! Thank you, Paul!

Paul Newcome

Happy to help. 👍️