P
Paul
Hi Guys,
Can anyone help me with this one?...
How do I get Excel to recognise 'any' date?
For example:
If a column of cells can contain any date between
01/01/2004 and 31/12/2006, how (in the next column) do I
get it to list all the dates in February as a 2, March as
a 3, and so on - so that they can be totalled...?!
Alternatively, how (at the bottom maybe) do I count all
of the dates entered for each month?
i.e.: A
01/02/2004
01/02/2004
13/02/2004
01/03/2004
05/03/2004
15/03/2004
15/03/2004
Total Feb 3 (??)
Total Mar 4 (??)
If anyone can help, it will be SO appreciated! Been at
this for 2 days now!?!...
Thank you in advance...
Can anyone help me with this one?...
How do I get Excel to recognise 'any' date?
For example:
If a column of cells can contain any date between
01/01/2004 and 31/12/2006, how (in the next column) do I
get it to list all the dates in February as a 2, March as
a 3, and so on - so that they can be totalled...?!
Alternatively, how (at the bottom maybe) do I count all
of the dates entered for each month?
i.e.: A
01/02/2004
01/02/2004
13/02/2004
01/03/2004
05/03/2004
15/03/2004
15/03/2004
Total Feb 3 (??)
Total Mar 4 (??)
If anyone can help, it will be SO appreciated! Been at
this for 2 days now!?!...
Thank you in advance...