Are 2 dates between today's date

I have 2 columns of data column A=start date; column B=end date. I want to
do an If statement to show "yes" if today's date is between these 2 dates,
and "no" if not.

A formula solution:
=IF(AND(A1<=TODAY(),B1>=TODAY()),"yes","no")

HTH. Best wishes Harald

"Re: Pivot Table/Query" <[email protected]> skrev
i melding news:[email protected]...
> I have 2 columns of data column A=start date; column B=end date. I want
to
> do an If statement to show "yes" if today's date is between these 2 dates,
> and "no" if not.
>
>