• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Enter cell value if between start and end date

DSM2019

New Member
Hello!
I'm trying to figure the best way to enter a percentage if falls between a start and end date. Example: If start date is 1/1/2019 and end date is 4/20/2019, and percentage value is 20, I want the columns for 1/1/2019-4/1/2019 to show 20% and if outside those dates, show "No Estimates".
I've tried several different IF MONTH/YEAR formulas, but I haven't been able to get it to work (especially if the start or end date is not in the same year).
I've attached a file of my current test and mock-up of what I'm trying to accomplish. I'm open to other ideas outside of formulas as well (if they exist)
Any advice is GREATLY appreciated!
 

Attachments

  • Date Test.xlsx
    11.2 KB · Views: 6
Sorry for the cell references it was lock
try this one..
=IF(AND(D$2>=$A3,D$2<=$B3),$C3,"No Estimate")
 
Thanks everyone for your help. I was able to get it to work using Luke M's formula. I greatly appreciate all your assistance!
 
Back
Top