Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
year formula
I'm sure this is very simple, but for some reason it's not working for me. I
have a log of training sessions provided to clients. I want to run a pivot table that totals the number of hours for the year. I track the date in the spreadsheet, so I wanted to add a column of "year" so that I can easily get totals per year. I want to reference the date column to populate the year for that date (I have hundreds of lines already so I don't want to do it manually) When i added the column & used the year function, it comes up with 1905 each time instead of the actual year. How do I accomplish this? thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
year formula
It's hard to say, without seeing the data. Are you sure that your dates are
correct? -- HTH Bob "jason" wrote in message ... I'm sure this is very simple, but for some reason it's not working for me. I have a log of training sessions provided to clients. I want to run a pivot table that totals the number of hours for the year. I track the date in the spreadsheet, so I wanted to add a column of "year" so that I can easily get totals per year. I want to reference the date column to populate the year for that date (I have hundreds of lines already so I don't want to do it manually) When i added the column & used the year function, it comes up with 1905 each time instead of the actual year. How do I accomplish this? thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Year formula | Excel Discussion (Misc queries) | |||
How do I crate a function for week of year + year in same cell. | Excel Worksheet Functions | |||
need formula 4 %change on both neg and pos movemnt year to year co | Excel Discussion (Misc queries) | |||
Combination Graph with current year and prior year sales | Charts and Charting in Excel | |||
Year-to-date year to date formula | Excel Worksheet Functions |