Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I name a range of dates?
How do I name a range of dates and then use that in a conditional formula.
For example: If Today's date falls between 12/30/05 through 2/10/06, Today is in Period 1. Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I name a range of dates?
Is the range of dates every date between those tow? If so, just use
=IF(ISNUMBER(MATCH(TODAY(),mydates,0)),"Period 1","") If you just have the two dates, test them =IF(AND(TODAY()=A1,TODAY()<=A2),"Period 1","") -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Rick" wrote in message ... How do I name a range of dates and then use that in a conditional formula. For example: If Today's date falls between 12/30/05 through 2/10/06, Today is in Period 1. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Possible to chart data for dates implicit within a range? | Charts and Charting in Excel | |||
Identifying Overlapping Dates within a range | Excel Worksheet Functions | |||
count number of years 2003 in a range of dates | Excel Worksheet Functions | |||
How do I get Excell to sort dates that range from 1800 to 1900's | New Users to Excel | |||
I have a list of dates that I need to count based on a date range | Excel Worksheet Functions |