@if Function with date ranges

  • Thread starter Thread starter Aaron Tech
  • Start date Start date
A

Aaron Tech

Hi,

I am wondering how to write this formula.

If a cel A1 is a date format. And I want to use @if to say: if A1 is
between October 15st and December 10th, do this formula, otherwise do this
formula.

I have the following @if syntax as a guide:

=IF(A1 is between October 15th and December 10th, (this function),(that
function))

Thanks
 
Hi,

I am wondering how to write this formula.

If a cel A1 is a date format. And I want to use @if to say: if A1 is
between October 15st and December 10th, do this formula, otherwise do this
formula.

I have the following @if syntax as a guide:

=IF(A1 is between October 15th and December 10th, (this function),(that
function))

Thanks
Click to expand...

=IF(AND(A1>DATE(2007,10,15),A1<DATE(2007,12,10)),YourFormula1,YourFormula2)

hth

Carlo
 
Back
Top