# Formula Question: "IF" function with date

Solved/Closed
Related:

- Formula Question: "IF" function with date
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Date formula in excel dd/mm/yyyy - Guide
- Excel grade formula - Guide
- Number to words in excel formula - Guide
- Position formula in excel - Office Software Forum

## 1 response

Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147

Sep 22, 2016 at 03:02 PM

Sep 22, 2016 at 03:02 PM

**Kim**, Good afternoon.

Try to use:

**P1**-->

**=IF(AND(B1>DATEVALUE("07/30/2016"), E1<DATEVALUE("07/31/2016")),"Yes","")**

Is this what you want?

I hope it helps.

--

Belo Horizonte,

**Brasil**.

Marcílio Lobão

Sep 22, 2016 at 03:09 PM