Posted to microsoft.public.excel.misc

external usenet poster

Posts: 15

How to count the last 30 days of activities

Have several columns with details
Column A5 and down=Date
Column B5 and down=Activity
Column C5 and down=Type of transportation

I now have 250 rows with activities from today and back in time.
My question is how can I have a variable in A1 where I can ask the last X
days activities. I will choose in A1 how many days back in time the number of
activities done.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Count Days more than 180 days prior to today	Gregory Day	Excel Worksheet Functions	4	March 28th 08 10:16 PM
When word says Install I want it count the days for 3 days w.o wee	CYNTHIA	Excel Worksheet Functions	1	March 23rd 08 05:28 AM
count days	Dan	Excel Discussion (Misc queries)	2	February 17th 08 11:16 PM
COUNT how many ROWS ago out of 10 days that the highest high in 10 days was made	rhhince	Excel Worksheet Functions	1	January 14th 07 09:56 PM
count days	Larry	New Users to Excel	3	June 2nd 06 04:24 PM

All times are GMT +1. The time now is 02:53 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us