I have a column of dates, and I want a formula that will subtract one month from that date. I can't simply subtract 30 from the date b/c sometimes that will...

Our local sales tax is 7% on the first $5,000 then 6% for evertthing over $5,000. What formula would I use?

I have EXCEL 2007 but most of the people I work with still have 2003 EXCEL. When I create a file and save it as an .xls (2003) file, it loses all the...

This is a formula that I have in my spresdsheet at L6 to answer Y or N to certain criteria. I need additional criteria added. I need the same formula but if...

I just resurected an old business plan from 2004 that I "PW protected". Am I hooped or is there a way to find out what that is? -- rustyrunrite

I have a template and need to populate certain fields with each customer's data, then save it as the customer's name, in a certain folder. What I've been...

Hi, I have subtotal at the bottom of a spreadsheet and is used when filtering on a group of rows. I have a problem that if I change the subtotal row or chnge...

Hello, Thanks for the help. - In Column A I have Salespeople names listed (row 1 is the header) - In column's B through M I have the months of the year,...

Does anyone have any suggestions on what kind of format is that for charting? The data range is...

How does excel treat dates that are before 1900? Is there a way to automatically format March 16, 1836 so excel recognises it as a value that can be used in...

We are using Analysis Excel tool, which contains lot of Formatting, Macros,User defined functions etc.,.This Excel tool is developed in Excel 2003 and it...

My web app generates a CSV file for import into Excel. One column is a URL that links back to the app to retrieve the original record. Right now Excel reads...

Hi, i need a macro to drag down some cells till the last active cell in "G" column. Ex: M N O 08:00:00 12:30:00 08:30:00 I...

Hello everyone! I still got a problem with a Solver optimization. I hope you can help me. There is a machine which can produce 2 products separately. In my...

How can I let other user's change the font colour without unprotecting sheet. Regards Chris

I am using Xls 2003 i want to make a list of item - let call it list A then i want to select one of the items in list A and another list (say list B) must...

kindly advice how to generate password at microsoft word & excel?

Column A of my spreadsheet has the addressee's name. Column F has the activity numbers that each addressee is resopnsible for. I want to create one letter to...

Excel 2003 Chart type: Stacked Column/Area Problem: The stacked column portion of the chart has 3 points of data on each column. The top 2 points of...

Hello Microsoft, I've spent about an hour on various Internet sites and discussing this in forums. Many seem to know it's not possible, but nobody has told...