@if Function with date ranges

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Aaron Tech - 19 Dec 2007 03:58 GMT

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

Reply to this Message

carlo - 19 Dec 2007 04:29 GMT

> Hi,
>
[quoted text clipped - 10 lines]
>
> Thanks

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

hth

Carlo

Reply to this Message

Rate this thread: