Returning a value if cell date is between two dates

What if I want those dates to be specified in this way - March 1, 2010 and October 31, 2012. That's what I really need to do.

Thanks!

Paul, I appreciate the help.

here's my formula =AND(A6>=10/1/2014,A6<=3/31/2016)*1
and it doesn't seem to be working. Any idea what I'm doing wrong?

Thanks!!

Awesome, Paul. That's the trick, thank you. The one thing I just couldn't get right was formatting the date. I have problems with this.

Thanks!!

Hi,

I have 4 tasks that are done in an order. First task1, then task 2 so on. Each task takes certain number of days.

I have calculated Start & End date for each task using MIN & MAX from a list dates Sheet 1(from the beginning of task 1 till the end of last task 4).

For example

Sheet 2

A ---------- B --------- C
(Task) (Start Date) (End Date)


Task 1 -- 1-Jan --- 6-Jan
Task 2 -- 7-Jan -- 12-Jan
Task 3 -- 13-Jan -- 14-Jan
Task 4 -- 15-Jan -- 16-Jan

Sheet 3

In this sheet I have a "column D" for Dates, starting from 1-Jan till 16-Jan (beginning of Task1 - end of task 4) D2:D17
In the same sheet I have marked "W" for working day, "H" for holiday & "A" for Absent, "S"for Sunday in "column F"

D -------- E ------- F

1-Jan Friday ------ W
2-Jan Saturday --- W
3-Jan Sunday ----- S
4-Jan Monday ----- H
5-Jan Tuesday ---- A
6-Jan Wednesday - W
.
.
.
16-Jan Saturday --- W

Now, I want to calculate the number of working days ("W") between start & end date for each task. For Task1, it should first check if each cell in column D (D2:D17) is in between 1-Jan & 6-Jan, if yes, count "W" in column F.

Excel 2016 has a function to calculate the number of working days between 2 dates , have you looked at this to meet your needs?