Posted to microsoft.public.excel.programming

Daniel

external usenet poster

Posts: 354

macro count date

Hi all
If I want a macro to count how many days from today, how can I do it? I
have excel column with sale date in the past and want to know which items are
sold more than 3 days ? The macro may be as below
IF
Today_date - date_sale 3
then
........
Thanks for your help
Daniel

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 a value in a date range based on a date in another workshee.	marsjune68	Excel Worksheet Functions	4	April 9th 09 10:31 PM
I tried to get around the problem of the pivot table field settingdefaulting to Count instead of Sum by running a macro of change the settingfrom Count to Sum. However, when I tried to run the Macro, I got error messageof run time error 1004, unable	Enda80	Excel Worksheet Functions	1	May 3rd 08 02:35 PM
I tried to get around the problem of the pivot table field settingdefaulting to Count instead of Sum by running a macro of change the settingfrom Count to Sum. However, when I tried to run the Macro, I got error messageof run time error 1004, unable	Enda80	Excel Discussion (Misc queries)	1	May 3rd 08 10:52 AM
Count number of cells with date <today's date	Cachod1	New Users to Excel	2	January 28th 06 02:37 AM
count the number of cells with a date <= today's date	Cachod1	New Users to Excel	3	January 27th 06 09:14 PM

All times are GMT +1. The time now is 01:02 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us