View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default 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