I have a dataset in which 1st column is the day of the month, 2nd column is the number of the month(1,2,3,4,5,6,7,8,9,10,11,12), 3rd column is the year, 4th, 5th and 6th columns are my data of interest. My problem is, I need a column between 3rd and 4th column with the values of day of the year(1-365 or 1-366). please help me to do this. I have the dataset of last 50 years.
my data is in my HDD. instead of Excel, we cant do it in C++ as it will be hectic to input data of day of the year for 50 years!! can t we make a column in C++ based on the data in the year column(leap year and not leap year)??
the file is in a database!! and i have data of 50 years. In that way I have 100 files. Doing the same thing in excel/ access as u told is really hectic. that is the reason why i am trying in C++. I dnt have much experience in C++. I have tried to write the code, but it is not working!! here is the code