Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calulate a value when date is in a range.
Hi there,
Please can you help! I am trying to calculate from a list of dates, which calender Period the date falls into. I have a table in excel with period number in first col1, period start date in col2, period end date in col3. I then have a list of about 500 dates and want to put in the column next to each date which period the date equals. I've tried nested if and offset functions but cannot figure it out!! If anyone can help, we would be most greatful. Meg |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calulate a value when date is in a range.
Let's say your dates are in Column A, and certain dates, such as holidays,
are in Column B, specifically B1:B8. Try this function: =ISNUMBER(MATCH(A1,$B$1:$B$8,0)) Fill down... Regards, Ryan--- -- RyGuy " wrote: Hi there, Please can you help! I am trying to calculate from a list of dates, which calender Period the date falls into. I have a table in excel with period number in first col1, period start date in col2, period end date in col3. I then have a list of about 500 dates and want to put in the column next to each date which period the date equals. I've tried nested if and offset functions but cannot figure it out!! If anyone can help, we would be most greatful. Meg |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Formula to calulate number of days passed from date to date | Excel Discussion (Misc queries) | |||
I am trying to calulate total time | Excel Worksheet Functions | |||
HOW DO I CALULATE A OVERTIME FORMULA | Excel Worksheet Functions | |||
Is there a way to calulate M-T-D or Y-T-D in Excelt? | Excel Worksheet Functions | |||
how to calulate time | New Users to Excel |