Home |
Search |
Today's Posts |
#1
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
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking computer dates (time) to spreadsheet dates that have formu | Excel Worksheet Functions | |||
Stop dates from showing as numbers - when formated as dates | Excel Discussion (Misc queries) | |||
Identifying unique dates in a range of cells containing dates... | Excel Discussion (Misc queries) | |||
Calculating number of days between two dates that fall between two other dates | Excel Discussion (Misc queries) | |||
Charting data against dates where dates are not at fixed intervals | Charts and Charting in Excel |