How do I find....

  • Thread starter Thread starter Smitch
  • Start date Start date
S

Smitch

Hey,
I have a coulmn with a heap of dates in the format of dd/mm/yyyy. I
want to find the earliest and the latest date in the list then
calculate the number of days that lie between them.

NB: not all the cells within the coumn will have a date, some cells
will be blank.

How do i do this?

Thanks Heaps
Smitch
 
ok, well i thought that prob was more complecated than it actually was.
Heres another qestion:

I have two colums, one contains a bunch of random dates in the form of
dd/mm/yyyy.
The 2nd column has a number next to each date.
I want to go down the columns and sum the number in the 2nd column for
each month. So i will end up with 12 totals, for each month.

Any tips?

Thanks in advance
Smitch
 
how about. The ranges must be the same size
=sumproduct((month(daterng)=2)*sumrange)
or
=sumproduct((month(a2:a22)=2)*b2:b22)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Format for making date calculations 4
how do I change the date format from yyyymmdd to mm/dd/yyyy 4
how do I set up a formula showing the day based on date? 4
Excel is seeing the date as dd/mm/yyyy 4
convert 13.11.2009 general to 13/11/2009 date, how to 1
Counting Occurrence of a Value within Cells 1
Date calculation and possible vlookup 1
Date/Time concatenation 4

Back
Top