Month is true, when it it between a date range.

[Geir Hogstad]

Hi,

I want the Month to be true. If one or more dates in a date range is in that month.

Please see excample file for details.

Best Regards

- Geir

[#2 · Accepted solution]

@Geir Hogstad 

In G8:

=IF(AND($E8<=G$4,$F8>=G$3),"T","F")

Fill to the right, then down or vice versa.

[#3]

@Geir Hogstad 

An Excel 365 formula that I like is

= LET(
  latestStart, IF(Start>monthBegin, Start, monthBegin),
  earliestEnd, IF(End<monthEnd, End, monthEnd),
  overlap, 1 + earliestEnd - latestStart,
  IF(overlap>0, overlap, "") )

placed in a single cell and allowed to spill.  The final line can be modified to give "T" and "F" if preferred.

[#4]

@Geir Hogstad 

For the possible benefit of Excel 365 users, the following shows a spreadsheet in which the display is controlled by a check box and conditional formatting.

[#5]

Thank you, it worked perfect.

- Geir