| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
show the date when it is later than today's date
I am looking for macro codes that will show the dates only if the date is
less than 181 days before today's date, e.g. today is 2008-11-25, 181 days before today is 2008-05-28. Date Date 2007-10-30 2008-05-28 2008-05-28 2008-02-22 2008-10-29 2008-10-29 2007-10-09 2008-04-09 2008-06-15 2008-06-15 2008-11-15 2008-11-15 Can anyone help? -- Aline |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
show the date when it is later than today's date
You can do this with a formual
Put this in B2 for the date in A2 =IF(Today()-A2<181,A2,"") and copy down You can also use Conditiona Formatting to highlight the dates in Col A Choose FORMULA is and enter =Today()-A2<181 "Aline" wrote: I am looking for macro codes that will show the dates only if the date is less than 181 days before today's date, e.g. today is 2008-11-25, 181 days before today is 2008-05-28. Date Date 2007-10-30 2008-05-28 2008-05-28 2008-02-22 2008-10-29 2008-10-29 2007-10-09 2008-04-09 2008-06-15 2008-06-15 2008-11-15 2008-11-15 Can anyone help? -- Aline |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
show the date when it is later than today's date
=IF(TODAY()-A1<=181,A1,"")
"Aline" wrote: I am looking for macro codes that will show the dates only if the date is less than 181 days before today's date, e.g. today is 2008-11-25, 181 days before today is 2008-05-28. Date Date 2007-10-30 2008-05-28 2008-05-28 2008-02-22 2008-10-29 2008-10-29 2007-10-09 2008-04-09 2008-06-15 2008-06-15 2008-11-15 2008-11-15 Can anyone help? -- Aline |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
show the date when it is later than today's date
Hi,
Are you really looking for macro code or are you looking for a spreadsheet formula? Because you are getting formulas not macro code as answers. Thanks, Shane "Aline" wrote: I am looking for macro codes that will show the dates only if the date is less than 181 days before today's date, e.g. today is 2008-11-25, 181 days before today is 2008-05-28. Date Date 2007-10-30 2008-05-28 2008-05-28 2008-02-22 2008-10-29 2008-10-29 2007-10-09 2008-04-09 2008-06-15 2008-06-15 2008-11-15 2008-11-15 Can anyone help? -- Aline |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
show the date when it is later than today's date
Hi Shane,
Thank you for asking. Yes, I was looking for macro codes. Here is the code I have now: ..Range("E3:E" & LastRow).Formula _ = "=SUMIF('C1'!$A$2:$A$500, D3, 'C1'!$I$2:$I$500)" The original date column is on the I column in the C1 sheet. What I wanted was that only 2008-05-28, 2008-10-29, 2008-06-15 and 2008-11-15 will show up on the E column of the active sheet. Thank you so much for the function =IF(Today()-A2<181,A2,""). It works! Hopefully you will be able to help me with macro codes. Thanks, Aline -- Aline "Shane Devenshire" wrote: Hi, Are you really looking for macro code or are you looking for a spreadsheet formula? Because you are getting formulas not macro code as answers. Thanks, Shane "Aline" wrote: I am looking for macro codes that will show the dates only if the date is less than 181 days before today's date, e.g. today is 2008-11-25, 181 days before today is 2008-05-28. Date Date 2007-10-30 2008-05-28 2008-05-28 2008-02-22 2008-10-29 2008-10-29 2007-10-09 2008-04-09 2008-06-15 2008-06-15 2008-11-15 2008-11-15 Can anyone help? -- Aline |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| conditional formatting for cell date to equal today's date | Excel Worksheet Functions | |||
| How to use Today's date in a cell and make it stay the same date | Excel Discussion (Misc queries) | |||
| I need today's date returned as date format in formula | Excel Discussion (Misc queries) | |||
| Count number of cells with date <today's date | New Users to Excel | |||
| count the number of cells with a date <= today's date | New Users to Excel | |||
Linear Mode
