data summary in week, month and year


T

timber

hi. i have data a2:a6000 as DATE. R2:R6000 Net P/L. now need dat
summary in weekly, monthly and yearly view of Net P/L.

i tried pivot table somehow cannot do above. can someone help here?

the DATE is daily date is from Monday to Friday. Now the weekly
monthly and yearly total of the NET P/L are needed. my first time usin
pivot table and unable to summarize the data using pivot table. or mayb
other method to data summary on weekly, monthly and yearly NET P/L
Thanks
 
Ad

Advertisements

F

Frank Kabel

Hi
if your dates are stroed as real Excel dates you could group within the
pivot table by month/year. Just slect the date column and open the
pivot table menu
 
T

timber

hi Frank, how is the date as 'real Excel dates'? i use English (US) dat
format. is that applicable to your method? i tried that date format an
couldn't. thanks
 
Ad

Advertisements


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

Top