| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
macro count date
On Jun 25, 1:19 pm, Daniel wrote:
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 I'm not sure I understand what you are asking, you're just asking how to calculate the difference between two dates right? I think that a simple search in Excel help would have shown that you can use the function DATEDIF(start_date,end_date,unit) to do what you want without a macro. Excel has lots of happy things regarding dates. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
macro count date
Y es, I want to compare 2 dates: today date and dates in a column (sale
date). In this column there are many dates and I want conditionally pick some rows which have more than 3 days IF Today()- column name 3 ? ................................................ Don't know how I can do it Thanks Daniel "lar.the.ever.so.slightly.lost" wrote: On Jun 25, 1:19 pm, Daniel wrote: 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 I'm not sure I understand what you are asking, you're just asking how to calculate the difference between two dates right? I think that a simple search in Excel help would have shown that you can use the function DATEDIF(start_date,end_date,unit) to do what you want without a macro. Excel has lots of happy things regarding dates. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
