Prev: Posting the workbook
Next: sumproduct with 4 conditions
From: BBD on 19 Mar 2010 15:59
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.


From: T. Valko on 19 Mar 2010 16:18
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")

--
Biff
Microsoft Excel MVP


"BBD" <BBD(a)discussions.microsoft.com> wrote in message
news:CB8BE456-C895-40CE-AE73-2A35E9E70016(a)microsoft.com...
>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.
>
>


 | 
Pages: 1
Prev: Posting the workbook
Next: sumproduct with 4 conditions