HELP NEEDED: Date Range in Excel

  • Thread starter Thread starter swoo
  • Start date Start date
S

swoo

Could someone please help me out with the following scenario:

I have a column which contains various dates. What I want to be abl
to do look at one cell and perform an IF function. IF the cell's dat
is between this date and that date THEN do this (mathematica
expression).

Does anyone know how to do this or can anyone suggest a better method
 
Hi
try something like
=IF(AND(A1>=DATE(2004,4,9),A1<=DATE(2004,4,13)),1,0)
 
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

SUMIF using date ranges & referencing account numbers 1
CONDITIONAL FORMATTING QUERY 0
Macro to insert a line when a value changes in a range 1
How to enter start and end date/time in excel based on some specific value. 7
Using Multiple Date Ranges to pull in Data 0
Excel Help with dates 2
Conditional formula's in excel-calculating with dates / age andaffiliation date calculus 3
Excel High lightng dates in future, today and past 1

Back
Top