Formula should automatically identify and move to next month

[vgn]

I have a data set on the left hand I have dates in series (i.e. 28-Feb-21, 1-Mar-21, 2-Mar-21 and so on..). Now against each date I want to return a value if a particular date is within that range. The challenge I am facing is the date range where the data is being captured is non-linear. I am attaching a sample, if any one can help me with an formula which can be used in cells B2:B14 where formula does not need to be changed when the date changes to next month.

I don't want to use macros as this will be used by non-macro users.
Any help would be highly appreciated !

 

[Fluff]

Hi & welcome to MrExcel.
How about

=SUMIFS(F:F,D:D,"<="&A2,E:E,">="&A2)

 

[vgn]

Hi & welcome to MrExcel.
How about

=SUMIFS(F:F,D:D,"<="&A2,E:E,">="&A2)

Thank you so much for this. It works perfectly

 

[Fluff]

You're welcome & thanks for the feedback.