title: In Google Sheets, how to check if Cell A (Date) is within the Date range of Cell B and C
body: <p>I have a sheet with a timeline that shows a month per row in column A and an amount in USD next to that month in column B.</p>
  <p>I want to be able to specify amounts in column G with a start and end date for that amount in columns E and F.</p>
  <p>What I am trying to achieve is that the values in column B are automatically calculated by looking at the start and end dates specified in columns E and F and then taking the corresponding value from column G if the date in column A falls in between the date range specified in E and F.</p>
  <p>I have found many suggestions for similar problems online but wasn't able to get any of them to work for my specific case. Any help is very welcome</p>