| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Display a value between certain dates
Hi
If dates are in A1:A100. I want to place a value in B1:B100. IE: all dates between 1 Feb07 and 28feb07 I would like to see a "1" in B1:B100. All dates between 1Mar07 and 31Mar07 a "2" etc. I have tried various "IF" fomulae but none of then work. Any suggestions would be appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need to pull current dates from list w/many dates | Excel Discussion (Misc queries) | |||
| need to convert list of dates to count no. of dates by week | Excel Worksheet Functions | |||
| Display dates from an Excel spreadsheet in a calendar? | Excel Worksheet Functions | |||
| I want to subtract 2 dates and display the result as months | Excel Worksheet Functions | |||
| Formating Dates for production schedule | Excel Discussion (Misc queries) | |||
Threaded Mode
