Spreadsheet: 845824d1697163748-if-values-between-x-and-y-date-each-year-output-yes-between-dates
Sheet: Sheet1

Date |  | Expected | So Far |  |  | From | 2000-09-15 00:00:00 | To | 2001-04-15 00:00:00 | Add-up Days
 |  |  |  |  | New date | From |  | To
 |  |  |  |  |  |  |  |  |  | Explanation
 |  |  |  |  |  |  | New add up date | Results |  | From Date and To Date are not in the same year
2000-02-16 00:00:00 |  | Nope |  |  |  |  |  |  |  | To keep it simpler, The From Date will be added  N days to 1st date of next year, And To Date will be added N days too
2000-12-09 00:00:00 |  | Yes
2001-03-16 00:00:00 |  | Yes
2001-05-31 00:00:00 |  | Nope
2001-10-03 00:00:00 |  | Yes
2002-02-14 00:00:00 |  | Yes
2002-04-27 00:00:00 |  | Nope
2002-06-21 00:00:00 |  | Nope
2002-07-08 00:00:00 |  | Nope
2002-08-05 00:00:00 |  | Nope
2002-08-11 00:00:00 |  | Nope
2002-10-05 00:00:00 |  | Yes
2002-10-16 00:00:00 |  | Yes
2003-08-27 00:00:00 |  | Nope
2003-11-02 00:00:00 |  | Yes
2004-01-28 00:00:00 |  | Yes
2004-02-09 00:00:00 |  | Yes
2004-03-02 00:00:00 |  | Yes
2004-03-07 00:00:00 |  | Yes
2004-06-24 00:00:00 |  | Nope
2004-10-06 00:00:00 |  | Yes
2005-06-15 00:00:00 |  | Nope
2005-07-22 00:00:00 |  | Nope
2006-01-26 00:00:00 |  | Yes
2006-03-02 00:00:00 |  | Yes
2006-05-05 00:00:00 |  | Nope
2006-07-02 00:00:00 |  | Nope
2006-12-31 00:00:00 |  | Yes
2007-05-17 00:00:00 |  | Nope
2007-06-12 00:00:00 |  | Nope
2007-07-30 00:00:00 |  | Nope
2008-05-07 00:00:00 |  | Nope
2008-11-30 00:00:00 |  | Yes
2008-12-26 00:00:00 |  | Yes
2009-03-18 00:00:00 |  | Yes
2009-03-29 00:00:00 |  | Yes
2009-07-14 00:00:00 |  | Nope
2009-07-28 00:00:00 |  | Nope
2009-11-22 00:00:00 |  | Yes
2009-12-13 00:00:00 |  | Yes
2010-06-08 00:00:00 |  | Nope
2010-10-10 00:00:00 |  | Nope
2010-11-26 00:00:00 |  | Nope
2011-06-29 00:00:00 |  | Nope
2011-08-12 00:00:00 |  | Nope
2011-10-23 00:00:00 |  | Yes
2011-11-20 00:00:00 |  | Yes
2011-12-26 00:00:00 |  | Yes
2012-03-10 00:00:00 |  | Yes
2012-07-11 00:00:00 |  | Nope
2012-07-27 00:00:00 |  | Nope
2012-12-26 00:00:00 |  | Yes
2013-01-11 00:00:00 |  | Yes
2013-07-29 00:00:00 |  | Nope
2013-08-10 00:00:00 |  | Nope
2014-03-08 00:00:00 |  | Yes
2014-12-26 00:00:00 |  | Yes
2015-03-29 00:00:00 |  | Yes
2015-07-03 00:00:00 |  | Nope
2015-08-17 00:00:00 |  | Nope
2015-09-27 00:00:00 |  | Yes
2015-10-09 00:00:00 |  | Yes
2015-11-08 00:00:00 |  | Yes
2015-11-17 00:00:00 |  | Yes
2016-02-22 00:00:00 |  | Yes
2016-06-06 00:00:00 |  | Nope
2016-08-30 00:00:00 |  | Nope
2016-11-16 00:00:00 |  | Yes
2016-11-20 00:00:00 |  | Yes
2017-02-02 00:00:00 |  | Yes
2017-04-12 00:00:00 |  | Yes
2017-07-14 00:00:00 |  | Nope
2017-08-05 00:00:00 |  | Nope
2017-08-22 00:00:00 |  | Nope
2017-10-12 00:00:00 |  | Yes
2017-10-17 00:00:00 |  | Yes
2017-12-15 00:00:00 |  | Yes
2018-01-06 00:00:00 |  | Yes
2018-01-24 00:00:00 |  | Yes
2018-06-09 00:00:00 |  | Nope
2018-06-09 00:00:00 |  | Nope
2018-07-31 00:00:00 |  | Nope
2018-11-19 00:00:00 |  | Yes
2019-03-27 00:00:00 |  | Yes
2019-05-20 00:00:00 |  | Nope
2019-11-11 00:00:00 |  | Yes
2020-01-02 00:00:00 |  | Yes
2020-02-03 00:00:00 |  | Yes
2020-07-23 00:00:00 |  | Nope
2020-11-21 00:00:00 |  | Yes
2020-12-12 00:00:00 |  | Yes
2021-01-19 00:00:00 |  | Yes
2021-05-30 00:00:00 |  | Nope
2021-09-19 00:00:00 |  | Yes
2022-02-24 00:00:00 |  | Yes
2022-07-29 00:00:00 |  | Nope
2022-12-22 00:00:00 |  | Yes
2023-02-01 00:00:00 |  | Yes
2023-06-15 00:00:00 |  | Nope