Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Determine if a month falls between two dates. | Excel Worksheet Functions | |||
formula to determine whether a date falls between two dates | Excel Discussion (Misc queries) | |||
How do I subtract dates to get a number in years or years & month | Excel Discussion (Misc queries) | |||
Determine years betwen 2 dates | Excel Worksheet Functions | |||
count no. of dates in a column that falls on certain month & year | Excel Worksheet Functions |