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

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

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

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

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