Home » Forums » Open Source Learning Center » Question and Answer

Amount of a date range that falls in another date range

Submitted by 1021km on 23 December, 2014 - 21:40

How can I determine the amount of a date range that falls into another date range?
Example:
Given a two week period: 01OCT2014 - 14OCT2014, how many days will fall into the following 1 year period: 10OCT2014 - 09OCT2015
Thanks!

‹ Extract string based on keyword Determine if text in a cell matches any text in an array ›
»