Calulate a value when date is in a range.

H

hardymeg

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
 
R

ryguy7272

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---
 

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

Formatting a spreadsheet to calculate difference in dates etc. 2
Show value from one cell in another cell if today falls between a date range 5
Help with SUMPRODUCT & converting date to value 1
Date range condition on multiple rows to get a tally 2
identify which years are contained within a range of dates 2
Multiple row comparison to sum potentially multiple values. 2
frustraded with conditional values return in a range of dates 1
Problem using IF statement with dates as part of the formula 4

Top