Display column details if row fits within date range

kburke

Help! I'm trying to do a multi-year roadmap with costs. What I have currently is

=IF([FY YR]@row = "2024", [Est Cost]@row), which works fine. However, what I REALLY need is for the Est Cost to show up in FY24 Cost not just if the year says 2024 in it, but instead if the date in the Start date field falls w/in our fiscal year, which is 10/1/23 - 9/30/24.

I've tried several variations but am not getting it right. Help!

kburke

Ahh, I think I got it. Anything I'm missing?

=IF(AND([Start Date]@row >= DATE(2023, 10, 1), [Start Date]@row <= DATE(2024, 9, 30)), [Est Cost]@row)

Paul Newcome

Not missing anything. That's pretty much what I was going to type out.