With 1.7 million freelancers, we'll match you with the perfect talent.
The client has made the following changes to the job.
Client prefers freelancers from:
You are still able to submit a proposal for this job.
The client prefers freelancers from
a different location.
I have a spreadsheet that has daily values from 1/4/1988 to present day. I am interested in your expertise to: 1) find the value that corresponds to the last day of the month for each month from January 1988 to May 2012. The spreadsheet data only has business days. There are no dates that are holidays or weekends. 2) once the last day of the month is identified (along with the value of the cell in the column next to that date) I want to delete the others days of the month. All I am interested in is finding the last day of the month and then copying that data to another worksheet. Currently I am going through each month by hand and selecting that days of the month other than the last day and hitting delete. My current method is time consuming and laborious.
Sign in or Register to see more