help with datedif function please

I have names and dates in columns , every time the name changes
I need the difference from that date untill to day's date. 
With the same name I need the difference between the dates  eg:

        A             b                         c
1     vit       05/12/2009    datedif untill    TODAY()
2     vit       20/11/2009    datedif between A1-A2
3     vit       04/07/2009        "          "        A2-A3
4     vit       24/06/2009        "          "        A3-A4
5     vit       15/06/2009        "          "        A4-A5
6     tom     21/11/2009    datedif untill     TODAY()
7     tom     08/11/2009    datedif between  A6-A7
8     tom     21/03/2009         "         "         A7-A8
9     tom     28/02/2009         "         "         A8-A9
10   swop   28/11/2009     datedif  untill      TODAY()
11   swop   04/11/2009     datedif between  A10-A11
12   tate     28/11/2009     datedif  untill      TODAY()
13   tate     18/06/2009     datedif between   A12-A13
14   tate     31/05/2009          "         "          A13-A14
15   tate     16/05/2009          "         "          A14-A15
16   tate     08/03/2009          "         "          A15-A16

and so on  The names are at random sequinces

Can some one please help


bill gras
0
Utf
12/24/2009 4:31:01 AM
excel.worksheet.functions 4936 articles. 2 followers. Follow

5 Replies
971 Views

Similar Articles

[PageSpeed] 48

Try this...

Use a cell to hold today's date

E1: =TODAY()

Enter this formula in C1:

=E1-B1

Enter this formula in C2 and copy down as needed:

=IF(A2=A1,B1-B2,E$1-B2)

Format column C as General or Number

-- 
Biff
Microsoft Excel MVP


"bill gras" <billgras@discussions.microsoft.com> wrote in message 
news:9204E0AD-4137-4AF4-A42D-DA2717FE15C5@microsoft.com...
>I have names and dates in columns , every time the name changes
> I need the difference from that date untill to day's date.
> With the same name I need the difference between the dates  eg:
>
>        A             b                         c
> 1     vit       05/12/2009    datedif untill    TODAY()
> 2     vit       20/11/2009    datedif between A1-A2
> 3     vit       04/07/2009        "          "        A2-A3
> 4     vit       24/06/2009        "          "        A3-A4
> 5     vit       15/06/2009        "          "        A4-A5
> 6     tom     21/11/2009    datedif untill     TODAY()
> 7     tom     08/11/2009    datedif between  A6-A7
> 8     tom     21/03/2009         "         "         A7-A8
> 9     tom     28/02/2009         "         "         A8-A9
> 10   swop   28/11/2009     datedif  untill      TODAY()
> 11   swop   04/11/2009     datedif between  A10-A11
> 12   tate     28/11/2009     datedif  untill      TODAY()
> 13   tate     18/06/2009     datedif between   A12-A13
> 14   tate     31/05/2009          "         "          A13-A14
> 15   tate     16/05/2009          "         "          A14-A15
> 16   tate     08/03/2009          "         "          A15-A16
>
> and so on  The names are at random sequinces
>
> Can some one please help
>
>
> bill gras 


0
T
12/24/2009 5:02:53 AM
...., or presumably just =IF(A2=A1,B1-B2,TODAY()-B2), without needing E1 ?
--
David Biddulph

"T. Valko" <biffinpitt@comcast.net> wrote in message 
news:usfZaZFhKHA.1540@TK2MSFTNGP06.phx.gbl...
> Try this...
>
> Use a cell to hold today's date
>
> E1: =TODAY()
>
> Enter this formula in C1:
>
> =E1-B1
>
> Enter this formula in C2 and copy down as needed:
>
> =IF(A2=A1,B1-B2,E$1-B2)
>
> Format column C as General or Number
>
> -- 
> Biff
> Microsoft Excel MVP
>
>
> "bill gras" <billgras@discussions.microsoft.com> wrote in message 
> news:9204E0AD-4137-4AF4-A42D-DA2717FE15C5@microsoft.com...
>>I have names and dates in columns , every time the name changes
>> I need the difference from that date untill to day's date.
>> With the same name I need the difference between the dates  eg:
>>
>>        A             b                         c
>> 1     vit       05/12/2009    datedif untill    TODAY()
>> 2     vit       20/11/2009    datedif between A1-A2
>> 3     vit       04/07/2009        "          "        A2-A3
>> 4     vit       24/06/2009        "          "        A3-A4
>> 5     vit       15/06/2009        "          "        A4-A5
>> 6     tom     21/11/2009    datedif untill     TODAY()
>> 7     tom     08/11/2009    datedif between  A6-A7
>> 8     tom     21/03/2009         "         "         A7-A8
>> 9     tom     28/02/2009         "         "         A8-A9
>> 10   swop   28/11/2009     datedif  untill      TODAY()
>> 11   swop   04/11/2009     datedif between  A10-A11
>> 12   tate     28/11/2009     datedif  untill      TODAY()
>> 13   tate     18/06/2009     datedif between   A12-A13
>> 14   tate     31/05/2009          "         "          A13-A14
>> 15   tate     16/05/2009          "         "          A14-A15
>> 16   tate     08/03/2009          "         "          A15-A16
>>
>> and so on  The names are at random sequinces
>>
>> Can some one please help
>>
>>
>> bill gras
>
> 


0
David
12/24/2009 9:17:23 AM
You'd have to do something for the last entry in the range. If the names are 
in A1:A10, dates in B1:B10, when you copy the formula down to row 10 then 
you get:

=IF(A11=A10,B10-B11,TODAY()-B11)

Assuming A11 and B11 are empty cells, then you get an incorrect result.

-- 
Biff
Microsoft Excel MVP


"David Biddulph" <groups [at] biddulph.org.uk> wrote in message 
news:WNqdnbrkJbpYrK7WnZ2dnUVZ8j6dnZ2d@bt.com...
> ..., or presumably just =IF(A2=A1,B1-B2,TODAY()-B2), without needing E1 ?
> --
> David Biddulph
>
> "T. Valko" <biffinpitt@comcast.net> wrote in message 
> news:usfZaZFhKHA.1540@TK2MSFTNGP06.phx.gbl...
>> Try this...
>>
>> Use a cell to hold today's date
>>
>> E1: =TODAY()
>>
>> Enter this formula in C1:
>>
>> =E1-B1
>>
>> Enter this formula in C2 and copy down as needed:
>>
>> =IF(A2=A1,B1-B2,E$1-B2)
>>
>> Format column C as General or Number
>>
>> -- 
>> Biff
>> Microsoft Excel MVP
>>
>>
>> "bill gras" <billgras@discussions.microsoft.com> wrote in message 
>> news:9204E0AD-4137-4AF4-A42D-DA2717FE15C5@microsoft.com...
>>>I have names and dates in columns , every time the name changes
>>> I need the difference from that date untill to day's date.
>>> With the same name I need the difference between the dates  eg:
>>>
>>>        A             b                         c
>>> 1     vit       05/12/2009    datedif untill    TODAY()
>>> 2     vit       20/11/2009    datedif between A1-A2
>>> 3     vit       04/07/2009        "          "        A2-A3
>>> 4     vit       24/06/2009        "          "        A3-A4
>>> 5     vit       15/06/2009        "          "        A4-A5
>>> 6     tom     21/11/2009    datedif untill     TODAY()
>>> 7     tom     08/11/2009    datedif between  A6-A7
>>> 8     tom     21/03/2009         "         "         A7-A8
>>> 9     tom     28/02/2009         "         "         A8-A9
>>> 10   swop   28/11/2009     datedif  untill      TODAY()
>>> 11   swop   04/11/2009     datedif between  A10-A11
>>> 12   tate     28/11/2009     datedif  untill      TODAY()
>>> 13   tate     18/06/2009     datedif between   A12-A13
>>> 14   tate     31/05/2009          "         "          A13-A14
>>> 15   tate     16/05/2009          "         "          A14-A15
>>> 16   tate     08/03/2009          "         "          A15-A16
>>>
>>> and so on  The names are at random sequinces
>>>
>>> Can some one please help
>>>
>>>
>>> bill gras
>>
>>
>
> 


0
T
12/24/2009 5:26:11 PM
Hi T.Valko
Thank you for your reply and your time 
the formula works perfectly ,that's just what I
was looking for !
-- 
bill gras


"T. Valko" wrote:

> Try this...
> 
> Use a cell to hold today's date
> 
> E1: =TODAY()
> 
> Enter this formula in C1:
> 
> =E1-B1
> 
> Enter this formula in C2 and copy down as needed:
> 
> =IF(A2=A1,B1-B2,E$1-B2)
> 
> Format column C as General or Number
> 
> -- 
> Biff
> Microsoft Excel MVP
> 
> 
> "bill gras" <billgras@discussions.microsoft.com> wrote in message 
> news:9204E0AD-4137-4AF4-A42D-DA2717FE15C5@microsoft.com...
> >I have names and dates in columns , every time the name changes
> > I need the difference from that date untill to day's date.
> > With the same name I need the difference between the dates  eg:
> >
> >        A             b                         c
> > 1     vit       05/12/2009    datedif untill    TODAY()
> > 2     vit       20/11/2009    datedif between A1-A2
> > 3     vit       04/07/2009        "          "        A2-A3
> > 4     vit       24/06/2009        "          "        A3-A4
> > 5     vit       15/06/2009        "          "        A4-A5
> > 6     tom     21/11/2009    datedif untill     TODAY()
> > 7     tom     08/11/2009    datedif between  A6-A7
> > 8     tom     21/03/2009         "         "         A7-A8
> > 9     tom     28/02/2009         "         "         A8-A9
> > 10   swop   28/11/2009     datedif  untill      TODAY()
> > 11   swop   04/11/2009     datedif between  A10-A11
> > 12   tate     28/11/2009     datedif  untill      TODAY()
> > 13   tate     18/06/2009     datedif between   A12-A13
> > 14   tate     31/05/2009          "         "          A13-A14
> > 15   tate     16/05/2009          "         "          A14-A15
> > 16   tate     08/03/2009          "         "          A15-A16
> >
> > and so on  The names are at random sequinces
> >
> > Can some one please help
> >
> >
> > bill gras 
> 
> 
> .
> 
0
Utf
12/25/2009 11:15:01 AM
You're welcome. Thanks for the feedback!

-- 
Biff
Microsoft Excel MVP


"bill gras" <billgras@discussions.microsoft.com> wrote in message 
news:BB518BF9-0BBC-4638-B8E6-68ED3CB8AD30@microsoft.com...
> Hi T.Valko
> Thank you for your reply and your time
> the formula works perfectly ,that's just what I
> was looking for !
> -- 
> bill gras
>
>
> "T. Valko" wrote:
>
>> Try this...
>>
>> Use a cell to hold today's date
>>
>> E1: =TODAY()
>>
>> Enter this formula in C1:
>>
>> =E1-B1
>>
>> Enter this formula in C2 and copy down as needed:
>>
>> =IF(A2=A1,B1-B2,E$1-B2)
>>
>> Format column C as General or Number
>>
>> -- 
>> Biff
>> Microsoft Excel MVP
>>
>>
>> "bill gras" <billgras@discussions.microsoft.com> wrote in message
>> news:9204E0AD-4137-4AF4-A42D-DA2717FE15C5@microsoft.com...
>> >I have names and dates in columns , every time the name changes
>> > I need the difference from that date untill to day's date.
>> > With the same name I need the difference between the dates  eg:
>> >
>> >        A             b                         c
>> > 1     vit       05/12/2009    datedif untill    TODAY()
>> > 2     vit       20/11/2009    datedif between A1-A2
>> > 3     vit       04/07/2009        "          "        A2-A3
>> > 4     vit       24/06/2009        "          "        A3-A4
>> > 5     vit       15/06/2009        "          "        A4-A5
>> > 6     tom     21/11/2009    datedif untill     TODAY()
>> > 7     tom     08/11/2009    datedif between  A6-A7
>> > 8     tom     21/03/2009         "         "         A7-A8
>> > 9     tom     28/02/2009         "         "         A8-A9
>> > 10   swop   28/11/2009     datedif  untill      TODAY()
>> > 11   swop   04/11/2009     datedif between  A10-A11
>> > 12   tate     28/11/2009     datedif  untill      TODAY()
>> > 13   tate     18/06/2009     datedif between   A12-A13
>> > 14   tate     31/05/2009          "         "          A13-A14
>> > 15   tate     16/05/2009          "         "          A14-A15
>> > 16   tate     08/03/2009          "         "          A15-A16
>> >
>> > and so on  The names are at random sequinces
>> >
>> > Can some one please help
>> >
>> >
>> > bill gras
>>
>>
>> .
>> 


0
T
12/25/2009 5:26:35 PM
Reply:

Similar Artilces:

Formula help #3
Sheet1 has a name in A1 & a number in B1, name in A2 number in B2 and s on (numbers will continually be changed). On sheet2 I used =a or = and so on (the results of =a or =b are the names from sheet 1). Wha I want to accomplish is every time I type =a or =b and the name appear I also want the result from sheet1 B1 and so on to appear in the cel directly below. Not very experienced just learning. Looking fo help -- Message posted from http://www.ExcelForum.com Hi Ljsimm You post is a bit vague, but if you mean you want B1 on sheet 2 to match up with the name on Sheet 1. Try: =IF(...

HELP! #2
I just had a cluster failover and fail back and for whatever reason, now when users go into Outlook and type the name of a public folder or newsgroup on the To: line they see the name of the group plus some sort of SID looking string next to it. For example, instead of just seeing thename of the group they are seeing: company.newsgroupname <newsgroupname34239492038902385092845923> What's going on? Help! Dan Dan, Are there any errors in the event logs pertaining to access of AD or anything like that? C. Smith Enso Technologies, Incorporated http://www.ensotech.com On Wed,...

Iterative Calculation help needed
I have the following information A1 - Balance at the beginning of calculation A2 - Annualized payment A3 - Interest rate divided by # of payments per year A4 - Number of years * # of payments per year I'm trying to calulate the total ((A1-A2)*(1+A3)) - I need to do this over and over up until I've don it A4 times. I can do it for each period but I want to do it all in one cell, i possible. How can I have it plug the new number into A1 and repeat th calculation A4 times. Thanks -- Message posted from http://www.ExcelForum.com Hi there You might find that the PMT function coul...

i am receiving every emai twice?? can anyone help with this issue
I would appreciate any advice cheers, See http://www.howto-outlook.com/faq/duplicates.htm -- Robert Sparnaaij [MVP-Outlook] Coauthor, Configuring Microsoft Outlook 2003 http://www.howto-outlook.com/ Outlook FAQ, HowTo, Downloads, Add-Ins and more http://www.msoutlook.info/ Real World Questions, Real World Answers ----- "ETA" <ETA@discussions.microsoft.com> wrote in message news:5939A41A-2CBC-415A-BA84-C14C2FD19084@microsoft.com... > I would appreciate any advice > > cheers, ...

Lookup Function in user form
I have a combo box (cboitem1) and a text box (txtprice1). I am using the code below to have txtprice1 fill with the corresponding price the worksheet: Private Sub Cboitem1_Change() If cboItem1 <> "" Then txtprice1.Value = Excel.WorksheetFunction.VLookup(cboItem1.Value, Sheets("Pizzas").Range("A1:B65536"), 2, False) End If End Sub It works perfectly when you enter an existing value in cboitem1. However if 'the user' accidently types a letter that is not the first letter of one of the existing items VB debugging pops up with error &qu...

Track in CRM function
Hello. Upon selecting the “Track In CRM” button from the CRM line in Outlook I have two questions based on situation: 1) If the contact exists in CRM it appears to attach the email but provides no notice unless you try to attach it again? True? 2) If the contact does not exist it attaches the email where? In v1.2 it opened a window and made the user create a record. I think it is attaching or tracking the email in CRM somewhere because trying to do it again, I'm asked if you want to attach/track it again. Does this make sense? By the way, we are using CRM 3.0 Thanks. After c...

Need HELP with Exchange Restore/Recovery
Details: 2003 sp2 Exchange Server Enterprise 2003 sp1 Server Enterprise C: drive is 100GB Logical Drive over x4 36GB drives in a RAID 5 set D: drive is 280GB Logical Drive over x5 70GB drives in a RAID 5 set Domain Controller Last night I upgraded our 2003 sp1 Exchange to sp2 + any O/S hot fixes and DST fix. No problem with the upgrade or hot fix, but @ about 200 a.m. I lost two of the five drives in the RAID 5 set (drive D) that had the exchange install. I’m currently replacing the hardware & bringing up the drives & going to recreate the D: drive. (server is bootable) I h...

Tracked changes function misbehaving
I have a simple workbook (2002) in which the Track Changes feature is enabled. End users have reported periodic problems with the contents of cells "mysteriously" changing. In process of investigating these, have found that when tracked changes are highlighted, the comments that describe changes are not always associated with the correct cell. Example, comment on cell B114 states "Changed cell B114 from '<blank>' to '12345'". In fact, contents of cell B114 is "67890" and contents of cell B104 is actually "12345". Has anyone...

Help!! Need Recovery!
So I went to open my excell file as usual and suddenly I have 10 or so instances openned. As I was closing them I saved one that turned out to be an old version, REAL OLD, like 2 weeks or so. No I desparataly need to get back to where I was. I tried to use the recovery utility under Microsoft Tools, but there are no available dates to revert to. I have no other way of reverting the document. Anyone know what to do? Any help would be greatly appreciated! Thank you.- Kjellster :D ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and ...

Sloooow. PLEASE HELP
Hi All, I have two questions first is where do I find the Windows 7 Disscussion Group. Have posted here because was unable to locate the windows 7 Discussion Group. My computer which is a SAMSUNG N110 3 months old has become very very very slow. It has Windows 7 installed I have upgraded the memory to two GIG. I have antivirus software and Anti Malware bytes installed. The problem i have is that the machine seems to slow down and sometimes crash whenever I click on internet explorer and many other applications such as office 2007 etc, etc. I have run the Norton Virus pr...

Rules causing outlook to shut down???, some body please respond
I am having the exactsame problem as chad with the messages seding over and over. And now outlook just shuts down just after opening, I am making an assumtion it also is in line with chads problem. Dot Subject: HELP!!! Rules causing outlook to shutdown??? From: "CM" <chad@cmhomeloans.net> Sent: 8/6/2003 8:24:30 AM For whatver reason I have narrowed down my problem with MS Outlook 2002 to the use of rules. For some reason when I have a rules setup to forward emails out to people on my work team it will automatically shutdown my Outlook and restart itse...

Help to build a table
Please help me to build a table similar to this one The number on the first column will change after 16 times, it will go in sequence from 1001, 1002, etc… The number in the second column will change after 4 times and it will go from 1 to 4 The number in the 3rd column will go from 1 to 4 2nd and 3rd column will keep the same pattern. Cabinet Shelf Location 1001 1 1 1001 1 2 1001 1 3 1001 1 4 1001 2 1 1001 2 2 1001 2 3 1001 2 4 1001 3 1 1001 3 2 1001 3 3 1001 3 4 1001 4 1 1001 4 2 1001 4 3 1001 4 4 1002 1 1 1002 1 2 1002 1 3 1002 1 4 1002 2 1 1002 2 2 1002 2...

List of kernel mode compatible functions
Hi, Is there a list of kernel mode compatible C/C++ functions (preferably for WDK 7600)? Thanks, Jan Wouldn't that be the WDK Help file? Thomas F. Divine "Jan M" <jan_m@jerseymail.co.uk> wrote in message news:e7fhXcanKHA.1548@TK2MSFTNGP02.phx.gbl... > Hi, > > Is there a list of kernel mode compatible C/C++ functions (preferably for > WDK 7600)? > > Thanks, > > Jan > Your right of course. I just didnt look hard enough. Jan ...

Set Out of Office (or a rule) to only function on weekends
Hello, I am trying to set up so that every weekend my internal e-mail gets forwarded to my home(smartphone) account. I can only find options to run a rule or out of office assistant to run for specific date ranges. How do I set up either a rule or the out of office assistant to 'push' mail to me only on weekends? HCA.CWT.RN wrote on Fri, 02 April 2010 09:04 > Hello, I am trying to set up so that every weekend my internal e-mail gets > forwarded to my home(smartphone) account. I can only find options to run a > rule or out of office assistant to run for spec...

FORECASTING SALES (please let this be a worksheet function)
Hi I have recently been given the task by my boss to forecast one of ou key customers monthly usage until monthly until end of 2006, I am starting with this customers indidual branches monthly usage fo the past 3 years, Some branches will have opened and closed during thi time, And i am looking to be able to predict monthly usage for the nex 18 months Has anyone got any idea's on the best way to forcast within excel, I a currently using trend (fomulae given to me on this sight) but people ar saying this is not the best way Exponentionally has been mentioned by a few of my collegues but...

Help writing a formula
I have a huge database that I need to create numbering for each line like this example: AK-233 (2 letter state, a dash, and 1-4 digit number), but the number doesn't change each line - sometimes the number will be duplicated on multiple lines because those lines have the same title, I also need to create another cell extending that letter/number combo that will differentiate the 1st cell. So the first cell stays the same if the title is the same. The second cell adds another layer of numbering to differentiate the first cell. See example: (Row1, Col 1-4) AK-1, AK-1-1, Title1...

My computer has stopped recognizing my memory card
This just happened today. The card was purchased the day after Thanksgiving so it's very new. It is a 4GB SD card from HP. I don't believe this is a hardware problem as my digital camera Lexar 1GB Memory Stick Duo card and adapter worked just fine today in the same slot. There has been no damage to the card. It has a write-protection lock on the side and I've tried the card with and without the lock on - neither way worked. I've also checked "My Computer" and confirmed that the computer is not listing my card as a drive any longer. I really need to get t...

Using a OR() like function in an IIF statement
Hello, I am trying to create an IIF statement to test if the first character in a field is a 1,2,8 or 9. Something like the following: IIf(Left([possible_SO_match],1)="1 or 2 or 8 or 9",[Possible_SO_Match],"No Match") Is there a way to create it without going to a 4 level nested IIF statement? Thanks, Kerry -- Message posted via http://www.accessmonster.com kkulakow via AccessMonster.com wrote: > Hello, I am trying to create an IIF statement to test if the first > character in a field is a 1,2,8 or 9. > Something like the following: > > IIf(Left([possib...

Receiving 2 of every message
I recently paid for a hotmail account so I could have larger storage and not get cancelled for any reasons such as not checking it often enough. I followed the instructions and put my service on Outlook Express. Now I'm receiving 2 of every message. What's up? Can I fix this? Thanks Darla ...

Help with RANK
Hi I need to rank 100+ numbers but I can't get the formula right. All th numbers are in one column, but not all the rows e.g. I need to Ran G1:G11 and G13:G25 and G32:G40 etc. How can you put in more than on reference? The cells G12,G26:G31 etc have numbers in them that I don' want ranked RANK(number,ref,order -- Message posted from http://www.ExcelForum.com =RANK(G1,MyList) where mylist is a selection of ranges defined with a single name, eg select all your ranges and do Insert / Name / Define, then call it MyList. Now use it in the rank formula and then copy the formula ...

HELP! Outlook Keeps Receiving Same E-Mail Messages
Hello: I keep getting the same 6 e-mail messages. This is after calling Norton and Comcast re receiving the same 3 e-mail messages (538 of them since midnight Dec 3!). Of course, it was not their problem, so it must be Outlook. Any thoughts. It sounds like you have an email message with a large attachment that is bogging down your account. What happens with the email is once you have connected to your ISP and clicked on the send/receive button if the connection is lost it will start over again until it can pull all of your messages in 1 sweep. You will need to log on to your accou...

Dialog getting hidden under HELP file
HI all, In my application I have a dialog & I launch HELP file from that dialog using F1 key. After that If I move the help file to one corner so that a part of the dialog is visible & click on the dialog & move it,it is moving,but when it comes over the HELP file,it is not overlapping but getting hidden under that. can anybody tell me what should I do to make it overlap the help file or give me a link that can help. Thanks in advance. Yes, that's how it is supposed to work. Help is a completely separate program, so its relationship to windows in ...

Re: Could someone please help me with formulas
sorry typo http://www.eaglepi.com/formula/example.xls "No" <no@isp.com> wrote in message news:... > I created a workbook and tried to explain the best I could how everything > should be. you can download the workbook at, > http://www.eaglepi.com/formlua/example.xls > > I really appreciate everyones help on this..... > > > "CLR" <croberts@tampabay.rr.com> wrote in message > news:%235IxtFEHFHA.2936@TK2MSFTNGP15.phx.gbl... > > Maybe in cell J2 you could put the formula =H2+I2, which would give you > the > > sum of the C...

HELP! Record Macro in TOOLS > MACRO is gone!
I was in Customize function trying to enable the Stop Recording toolbar and now in TOOLS > MACRO the Record Macro option is gone. I'm working on a project and I need this back. Can someone help? I'm using Excel 2003. Thanks, Joe M. Try this: In the customize window > click the Options tab > push the reset toolbars & menus button. Exit excel and re-load it Micky "Joe M." wrote: > I was in Customize function trying to enable the Stop Recording toolbar and > now in TOOLS > MACRO the Record Macro option is gone. I'm working on a ...

Updates not installed
KB976884, KB976416, and KB977304 have failed numerous times. Why? Is there a specific reason? What can I do? Cherry wrote: > KB976884, KB976416, and KB977304 have failed numerous times. Why? > Is there a specific reason? What can I do? So you have Microsoft Works and Microsoft Office 2007 installed? Or just Microsoft Works and some 'viewers' for Microsoft Office 2007? Or had Works installed but installed Office 2007 and did not fully remove Works? Or just Outlook 2007 and InfoPath 2007 and Microsoft Works? Have you tried downloading the patches manually and ...