John D replied to Daniel Rakers on 29-Jan-11 05:28 PM
Hi Daniel
Try this: =IF(AND(OR(A8="",V8="")),"",IF(A8="",TODAY()-A8,V8-A8))
HTH
John
Daniel Rakers replied to John D on 29-Jan-11 06:22 PM
Hey John,
It was the same reference cells in the original formula you edited for me: =IF(AND(OR(A8="",V8="")),"",IF(A8="",TODAY()-A8,V8-A8))
This is what I have so far for my other formula but I was having the same issue were the field shows a number (18) not blank when the end date has not been input yet? It does only track work days no holidays. See below:
=IF(A6="","",NETWORKDAYS(A6,IF(V6="",TODAY(),V6)))
As I said I'm not very good yet with Excel just a beginner. I also do not want to necessarily include holidays if there may be 2 versions you can help with
I appreciate all your help.
Dan
John D replied to Daniel Rakers on 29-Jan-11 06:44 PM
Is it this that you want, you don't need to use the reference for holidays, just ignore it.
=IF(AND(OR(A6="",V6="")),"",NETWORKDAYS(A6,IF(V6="",TODAY(),V6)))
John
John D replied to Daniel Rakers on 29-Jan-11 07:17 PM
Hi again
Just Google "Books on Excel formula" you can go on Youtube and do a search for excel formula and it's full of video to watch.
If you read these excel forums and try to solve some of the problems are just check the answers others post that would help.
Don't expect to be an expert overnight, I'm not.
The more you learn, the more you realize you know nothing..(-:
Keep on typing
John
Jackpot . replied to John D on 29-Jan-11 10:42 PM
Hi John
Have you tried the formula you posted.
What does the AND() do in your formula.
Try the formula keeping V6 blank..The OR() statement will not allow the formula to exeucte NETWORKDAYS() if V6 = ""; which is not what the OP is looking for..
=IF(A6="","",NETWORKDAYS(A6,IF(V6="",TODAY(),V6)))
Excel formula / macro integrating with font colors? Excel
am looking for the a macro formula, or an excel formula. . . I have an AR Aging report which is very complex. It is broke into 2 sections within the same sheet. The 1st section is grouped by type of customer and the 2nd section is actually aging the amount due. The 2nd section is font-colored coded according to aging (green font is 1-30, yellow font is 31-60, 61-90 and red font change the font of section 1 to reflect the same color of font in section 2? Now as a twist, section 1 is formulated to look at the group, the balance F2 is column title, C4 is cell group title, E4 is the amount from sec 2 aging balance. Any assistance would be appreciated. Thanks! ~Dawne Excel Programming Discussions Excel (1) Macro (1 write a macro to highlight cells in section 1 based on the highlighting in section 2. . . From your post it is not clear what the logic will be. . . If you can
Sum multiple criteria with a range >than and
a range > than and <than Excel than, and, <, than" / > Hi, Using Excel 2003. I have 2 worksheets. One with data as list; the other I want to use as summary. I've used the sumproduct which works for column b title for aging <30 and for column G for aging > 120, but I need to adapt formula when the other columns have a aging range, i.e. > 90 and less than <120. I haven't been able to figure as an array. Here is last example, which obviously doesn't work. SUMPRODUCT((data!$A$2:$A$468 = $A$6)*(AND(data!$G$2:$G$468> 90, data!$G$2:$G$468<121))*(data!$H$2:$H$468)) TIA Excel Worksheet Discussions Microsoft Excel (1) Excel 2003 (1) SUMPRODUCT (1) Skaria
12 07:51 PM how to show following criteria using sql storeprocedure Display records by aging ie , count Type1 Type2 1 day 10 5 2 days 20 6 3 days 30 10 4 days 40 12 5 - 10 days 50 reply. Well, Let say InsertDate is datetime column in SQL table. Type 1 and Type 2 are 2 additional columns in the same table. 1 day = the day before selected day (ie, input parameter date) 2 day = selected day - 2 can u describe more specifically. . .the design of your table . . so that you get your get 1 day = the day before selected day select DATEADD( DAY , -1, '04 / 14 / 2011' ) 2 day = selected day - 2 select DATEADD( DAY , -2, '04 / 14 / 2011' ) hope this. . . . @inputDate SELECT DATEDIFF(d, InsertDate, @inputDate
Update Failures Windows Server
Hi All Our office server is an aging P4 / 2.66GHz box running SBS2003 SP1, Exchange at SP2. 4 years ago it was upgraded from again & regards Ex-Engineer keywords: Update, Failures description: Hi All Our office server is an aging P4 / 2.66GHz box running SBS2003 SP1, Exchange at SP2. 4 years ago it was upgraded from
AR aging by customer address DataBase
Have an immediate to need to create an AR aging report outside of GP using SSRS. Need to be able to report aging based on Customer and Address not just by customer. This includes receivables as well. Great Jivtesh Dynamics Blog : http: / / www.jivtesh.com / I am looking to create an SSRS AR aging by customer report. AR inside of Dynamics GP 9.0 is by customer only and 9.0 SP1. We are on SQL 2K5 SP2. Have you looked at the AR Aging with Options in GP, it allows by State, ZipCode, Phone Number . . . Do you want by Address 1 and Address 2 ? Needs to be by customer address maintenance RM00102 table not by RM00101 tab le. Mail com I have mailed you instructions about the reports. Tmack, Are you asking for an aging report by customer and by bill to depending on what address they enter during the data entry of the invoices? Gerald keywords: AR, aging, by, customer, address description: Have an immediate to need to create an AR aging report
"This zone can be scavenged after: timestamp missing. . " Windows Server
This zone can be scavenged after: timestamp missing. . " Windows Server I just enabled aging and scavenging on my production domain in preparation for the move to it in the upcomming weeks, and in my test environment if I look at Zone Aging / Scavenging Properties, down at the bottom I see Date and time: 5 / 23 / 2008 2:00:00PM" however, on my production domain, if I check that same area. . beside the 1) Publishes (1) Amereast (1) Enable it on the properties of the server, Advanced tab. Aging and Scavenging needs to be enabled at server level and zone level. I did. Here's the scoop. I have 5 dc's / dns servers. 3 here(amereast-dc1, 2 and 5) and 2 in dublin (emea-dc1 and 2). I enabled aging and scavenging on amereast-dc5(my win2k3 DC. . ) the rest are win2k. I enabled it
The current AR aging and historical AR aging are yielding different results. When running the historical aging, all returns in the history for a customer are being grouped into the current amount. . .but these returns are not shown in the Aging with Options report. Any ideas why the aging would show returns in this way? I am trying to balance the subledger with the for 12.31.07, but I cant do that until I can run a correct aging! Great Plains Discussions Report (1) JoeFirst (1) December (1) Mariano (1) Sheila (1) Gomez (1 Unapplied Credit Amounts' - ensure that it is ticked. Then, ensure that you have run the Aging process ('Routines / Aging') before you try the reports again. Those are 2 basic things to
aging 'translation' help Windows Server
If I run this command: dnscmd DNSERVER1 / enumrecords 2.16.172.in-addr.ar pa @ > I get output that looks like this: [Aging:3550619] 900 PTR ls1243538c. [Aging:3543228] 900 PTR ls1243690g.bobo.org. [Aging:3532550] 900 PTR ls1226502a.bobo.org Aging:3527173] 900 PTR ls1199783g.bobo.org. [Aging:3526379] 900 PTR ls1167719d.bobo.org. [Aging:3525329] 900 PTR ls1167199d.bobo.org. [Aging:3522831] 900 PTR ls1213216c.bobo.org. Does anyone
DHCP Recovery Windows Server
a network with about 100 Windows XP Pro desktops, and 4 Windows Server 2003 servers (2 DCs, 2 member servers). The "main" DC (it holds all of the FSMO roles) is also my it. Thanks! Just knowing that helps a lot! Here is the result: Dhcp Server 10.2.1.1 Add Class "Default Routing and Remote Access Class" Dhcp Server 10.2.1.1 Add Class "Default BOOTP Class" "User class for BOOTP Clients" 424f4f54502e4d6963726f736f6674 0 b Dhcp Server 10.2.1.1 Add Class "Microsoft Windows 2000 Options" "Microsoft vendor-specific options for Windows 2000 Clients" 4d53465420352e30 1 b Dhcp Server 10.2.1.1 Add Class "Microsoft Windows 98 Options" "Microsoft vendor-specific options for Windows 98 Clients" 4d534654203938 1 b Dhcp Server 10.2.1.1 Add Class "Microsoft Options" "Microsoft vendor-specific options applicable to Windows 98 and Windows 2000 Clients" 4d534654 1 b Dhcp Server 10.2.1.1 Add Optiondef 249 "Classless Static Routes" BINARY 0 comment = "Destination, mask and router