If then between two dates

B

BBD

I am trying to distribute revenue evenly between two dates. I have in one
cell the beginning of the project. I have in another cell the end of the
project. One my spreadsheet, I am referencing the month to determine if it
falls betwen the project dates. I thought it was an if(and statement but it
doesn't return the answer. Any suggestions would be greatly appreciated.
 
T

T. Valko

Try this...

A1 = project start date
B1 = project end date

D1 = some date

To test whether the date in D1 falls within the start and end dates
(inclusive) for the project:

=IF(AND(A1<=D1,B1>=D1),"Yes","No")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating a Search using a combo box and then creating a report. 4
Transfer data between two tables 3
IF - Date falls between two dates, place here 3
Show value from one cell in another cell if today falls between a date range 5
SUMIF between date range 0
Expanding Date Formula 0
Default IF Date Is between 2 Dates then output additional column 1
Formula to figure out months between two dates 3

Top