Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 5th 20, 08:23 PM
Junior Member
 
First recorded activity by ExcelBanter: Jan 2020
Posts: 1
Lightbulb Determine if a month falls between two dates - multiple years

Hi,

I am attempting to write a formula to determine if a month falls between two dates which may range multiple years. With this, I can determine how much work there is for each month to chart a bar graph for a visual.

Below and attached are some sample data:

From Date To Date
6/1/2019 8/30/2019
11/15/2019 2/13/2020
12/31/2019 3/30/2020
1/19/2020 4/18/2020
3/10/2020 6/8/2020
4/4/2020 7/3/2020
11/29/2020 2/27/2021

Thanks for your help in advance!
Attached Files
File Type: zip Excel Test Data.zip (12.0 KB, 13 views)

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Determine if a month falls between two dates. Robert R Excel Worksheet Functions 5 October 2nd 13 01:41 PM
formula to determine whether a date falls between two dates lolan7 Excel Discussion (Misc queries) 7 February 19th 09 12:05 AM
How do I subtract dates to get a number in years or years & month jude Excel Discussion (Misc queries) 2 August 25th 06 08:02 PM
Determine years betwen 2 dates Darren Excel Worksheet Functions 2 May 3rd 06 05:26 PM
count no. of dates in a column that falls on certain month & year RawSugar Excel Worksheet Functions 2 October 20th 05 10:50 PM


All times are GMT +1. The time now is 09:54 AM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017