Determine a term within a date range

[Ruegen]

I'm wondering how in VBA to make a function that gets a term name/description if the date range falls within the same date range as the term



so for example if the date is 1/8/2015 - 12/12/2015 then it is term 4

if date from and date until between the above dates then = term 4

not sure how I would make this out in VBA and I hope that it is fast (i.e. convert to clng() )

[orange]

Please describe Term and its attributes.
I'm not sure from this Aug-Dec is a term??

1/8/2015 - 12/12/2015 then it is term 4

Does Term have a TermStart and TermEnd?
What is data type?

possibly
if termStart >= RangeStart AND termEnd <=RangeEnd ???

There is an example here.Old post

[trevor40]

check out the DATEPART Function (VBA), it can use 'q' as an interval. maybe what you need?