| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date Problem: Between 2 dates
Can anyone help, I have a mixed set of dates and like to produce a graph that
shows the number of dates between to dates. To show something like 2004 June July Aug Sept 2005 June July Aug Sept 2006 June July Aug Sept |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Date Problem: Between 2 dates
Do you mean from 1st June to 30th September?
You can just subtract the earlier date from the later date and format the cell as number with 0 dp to get the number of days between two dates. Hope this helps. Pete Mike wrote: Can anyone help, I have a mixed set of dates and like to produce a graph that shows the number of dates between to dates. To show something like 2004 June July Aug Sept 2005 June July Aug Sept 2006 June July Aug Sept |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Date Problem: Between 2 dates
Pete
Sorry for the poor explanation. If you have 300 dates over 4 year, what i would like to know is how to count the number of dates between to dates; so between say 1st july 2004 and 31 july2004. Then with this information, make a graph to show it. Mike |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Date Problem: Between 2 dates
Sorry, I still don't understand what you are trying to do. Can you post
an example of the data you have along with what you want to do with it? Pete Mike wrote: Pete Sorry for the poor explanation. If you have 300 dates over 4 year, what i would like to know is how to count the number of dates between to dates; so between say 1st july 2004 and 31 july2004. Then with this information, make a graph to show it. Mike |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Date Problem: Between 2 dates
If your dates are in A1:A300 to count the number of dates in that range that fall between a date in H1 and a later date in H2, either =COUNTIF(A1:A300,"="&H1)-COUNTIF(A1:A300,""&H2) or =SUMPRODUCT(--(A1:A300=H1),--(A1:A300<=H2)) -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=567181 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Deleting time part of a Date, subtracting dates | Excel Discussion (Misc queries) | |||
| Charting count of unique dates in a list | Charts and Charting in Excel | |||
| add/subtract dates problem in Excel..... | Excel Discussion (Misc queries) | |||
| How do I calculate if a date is in a certain time frame? | Excel Worksheet Functions | |||
| search for latest date | Excel Worksheet Functions | |||
Hybrid Mode
