| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date Range displayed in header
=text(min(a1:a10),"m/d/yyyy") & " - " & text(max(a1:a10),"m/d/yyyy")
Bdadmin wrote: I am attempting to put the range of MIN and MAX dates pulled from a column. I would like it to look like: Date Range: 9/6/2006 - 10/26/2006 from a column like this: Date 09/06/2006 09/06/2006 09/10/2006 10/12/2006 10/26/2006 Thanks in advance BD -- Dave Peterson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return info based on Date Range | Excel Worksheet Functions | |||
| Conditional formatting based on date range | Excel Discussion (Misc queries) | |||
| summing a date range | Excel Discussion (Misc queries) | |||
| how to check if date falls within range | Excel Worksheet Functions | |||
| adding occurrences for date range | Excel Discussion (Misc queries) | |||
Threaded Mode
