"Grouping dates"

[Marwan69]

Dear Gents,

I've got a data prepared by dates since 5 yrs back till today. I'd like to analyse the first year and the second year...etc. and from the inception to 5 yrs.

i.e:

[TABLE="width: 81"]
<tbody>[TR]
[TD="width: 81"] 08/01/2017
[TABLE="width: 81"]
<tbody>[TR]
[TD="width: 81"] 09/01/2017
.[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
.
.
[TABLE="width: 81"]
<tbody>[TR]
[TD="width: 81"] 11/07/2018

Hope is clear.

Manythamks,[/TD]
[/TR]
</tbody>[/TABLE]
Marwan

 

[Peter_SSs]

You have given very little information. I suggest that you investigate Pivot Tables that have the ability to group dates.

 

[PhilS2520]

Hi Marwan,

OK, when you say:
I'd like to analyse the first year and the second year...etc.

What do you mean? What analyses do you need to make and if you can give an example (an articulate, detailed example) would help.

Dear Gents,

What you think there are no ladies here?

 

[Marwan69]

Thanks all whether ladies or gentlemen.

I have a list of dates since 2013 till 2018 listed by day. I want to find the return of a stock for the first year, three years and for the five years.

Hope that is clear and my apologies for any inconvenience.

Many thanks,
Marwan