|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
March 19th, 2010, 07:59 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If then between two dates
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. 
|
|
#2
March 19th, 2010, 08:18 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If then between two dates
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" wrote in message ... 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.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
