Date Problem: Between 2 dates

[Guest]

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

 

[Pete_UK]

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

 

[Guest]

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

 

[Pete_UK]

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

 

[daddylonglegs]

If your dates are in A1:A300

to count the number of dates in that range that fall between a date i
H1 and a later date in H2, either

=COUNTIF(A1:A300,">="&H1)-COUNTIF(A1:A300,">"&H2)

or

=SUMPRODUCT(--(A1:A300>=H1),--(A1:A300<=H2)