| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Business Days
In need to be able to highlight a row if the date in that row is greater than
10 business days. I have already stored today as a variable called "today." -- Regards, Michael |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Business Days
Use the WORKDAY function. You could set up Conditional Formatting using:
"=WORKDAY(today,10)$A$1" Give that a try. Matthew Pfluger "Michael from Austin" wrote: In need to be able to highlight a row if the date in that row is greater than 10 business days. I have already stored today as a variable called "today." -- Regards, Michael |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Business Days
On Wed, 19 Mar 2008 10:03:01 -0700, Michael from Austin
wrote: In need to be able to highlight a row if the date in that row is greater than 10 business days. I have already stored today as a variable called "today." Go to Tools Addins and make sure "Analysis Toolpak - VBA" is checked. In the VBE, go to Tools References and set a reference to atpvbaen.xls. Then you can call the NETWORKDAYS function directly Sub HighlightDays() If Abs(networkdays(Sheet1.Range("A4").Value, Date)) 10 Then Sheet1.Range("A4").EntireRow.Interior.Color = vbYellow End If End Sub -- Dick Kusleika Microsoft MVP-Excel http://www.dailydoseofexcel.com |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Business Days
Worked.. Thanks So much...........
-- Regards, Michael "Matthew Pfluger" wrote: Use the WORKDAY function. You could set up Conditional Formatting using: "=WORKDAY(today,10)$A$1" Give that a try. Matthew Pfluger "Michael from Austin" wrote: In need to be able to highlight a row if the date in that row is greater than 10 business days. I have already stored today as a variable called "today." -- Regards, Michael |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Business Days
Worked!!!! Thanks so much.........
-- Regards, Michael "Dick Kusleika" wrote: On Wed, 19 Mar 2008 10:03:01 -0700, Michael from Austin wrote: In need to be able to highlight a row if the date in that row is greater than 10 business days. I have already stored today as a variable called "today." Go to Tools Addins and make sure "Analysis Toolpak - VBA" is checked. In the VBE, go to Tools References and set a reference to atpvbaen.xls. Then you can call the NETWORKDAYS function directly Sub HighlightDays() If Abs(networkdays(Sheet1.Range("A4").Value, Date)) 10 Then Sheet1.Range("A4").EntireRow.Interior.Color = vbYellow End If End Sub -- Dick Kusleika Microsoft MVP-Excel http://www.dailydoseofexcel.com |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating 10 Business Days from the Last Business Day of the Mon | Excel Worksheet Functions | |||
| BUSINESS DAYS - Need function that will list next 3 business days. | Excel Programming | |||
| Business Days Only | Excel Discussion (Misc queries) | |||
| How to calculate # days between business days | Excel Programming | |||
| Normal Days to business days | Excel Programming | |||
Linear Mode
