On the Excel 2003 S.Sheet that I am working on, I have client start dates. I have made a table next to this, with individual cells for each month, going back 3 yrs. I wish to look at the start dates and extract how many people started in August 05 and then, having copied the formula down, queary the same data to show Sept 05, Oct 05 etc.
I have tried placing this as two tables in general format between two dates so that the number of days is displayed (Since 1//1/1900) and using a countif statement to measure between upper and lower values. No luck as, although accepting number inputs within the formula, doesn.t like locational references for some reason. Arghhh. Help.
2007-03-29
04:46:39
·
2 answers
·
asked by
Alice S
6
in
Software