Quote:
Originally Posted by saffron
Hello, I am new to this forum and appreciate any assistance. I have looked for answers to my problem but am not finding anything. What I want to do seems simple but I can't seem to figure it out and will probably kick myself once I get the assistance. I have a simple spreadsheet to track install dates. All I want is to count how many times each year is represented. The column is in date format 1/1/2005 the range is G1:G175. The actual dates vary through the current year. Thank you in advance!
|
Hi,
Have a look at the attached.
I've included a worksheet with an example for Excel 2003 and one for later versions as they use different formulas, although the 2003 version will work in later versions also.
I've added date cells to give a start date (and end date in the case of 2003).
You could hardcode the dates into the formula, but if you ever need to change the year and recalculate it's easier to change one cell than it is to change formulas.
Hope that's of help.
Let me know if I've misunderstood your requirement.
S.