Doing Date Comparisons

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have specific ranges of dates, such as between 1/1 and 1/10 of a given year, and I want to know if a date entered falls between those dates. However, as I mentioned, I have a range of dates so I need to scan all of the dates in the range before I get a true or false. Any ideas?
 
Hi
does your range of dates consist of 'real' Excel dates. Your example of
'1/1' seems to idnicate either a custom format or a text value?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date range within a date range 2
Excel Help with dates 2
Calculating diff between date/ time only between certain hours 5
Excel Vba to change displayed year automatically. 14
Can I use "OR" in two auto-filters/custom filters? 1
Date between date range 1
I need help with this program written in Visual Basic for Excel 2007. 4
Calculate # of months if a date is given 4

Back
Top