Hi alphazero, and welcome to the board.On 2002-08-26 07:28, alphazero wrote:
I have a list of dates. I want to be able to count how many of those fields have dates that are 90 days or less from today's date.
Sorry if this has been covered before... I did try a search, but didn't find anthing.
Thanks!
On 2002-08-26 07:52, alphazero wrote:
Thanks for the quick replies. I tried the above formala, but am only getting a "volatile" message about my cell's value.
To be more specific, I have a list of dates, all of which are in the past. Of that list of dates, I want to be able to open the excel file at any time (any day) and have a cell that tells me how many cells have dates in them that are 90 days or less from today's date (today's date = date the file is open - so value will change from day to day).
I hope that is clear. Thanks for the help so far. /board/images/smiles/icon_wink.gif
On 2002-08-26 08:55, alphazero wrote:
Ok. One more challeng. :wink:
What if I wanted to filter these with another variable that exists on each line?
I.e. - I have list of dates with people's names attached to them... and I only want count the ones that are associated with "Joe Schmoe". Is this possible?
On 2002-08-26 08:55, alphazero wrote:
Ok. One more challeng. :wink:
What if I wanted to filter these with another variable that exists on each line?
I.e. - I have list of dates with people's names attached to them... and I only want count the ones that are associated with "Joe Schmoe". Is this possible?