If a cell returns a date between the 2nd and last day of a given month. What worksheet function can be used to return the 1st day of the following month? --...

I am trying to create an "IF" function that will use the text entered in a previous cell to fill in the current cell. I am doing this to break the US up by...

For document control purposes I'd like to have a cell display the most recent date that the document was modified.

I have created a worksheet which uses a large number of SUMIFs to create a table (36 columns by 75 rows therefore 2700 SUMIFs) which picks the results from a...

Excel spreadsheets embedded in Word are functional, however, once the file is converted to a PDF file, the Excel spreadsheets are no longer accessible. Is...

I have a daily sales workbook that I need to extract the sales from yesterday, and have it filter to another worksheet for the current month. I know to use...

I would expect to see something like either 4.25 or 4:15 or ??

I have a large excel document that I am constantly cutting, copying and pasting data in. When I cut or copy a cell and paste it somewhere else, I have to...

I have an Excel 2003 workbook that contains several worksheets showing data that I want to be able to add to one of the worksheets and use as a staff roster....

Sheet 'A' has cell index till DM200. I want to pull the data from of these rows in Sheet 'B' only when column DM of that row in sheet A says "PAST". I do not...

I have a worksheet in which one column is a date and the other is a text value (such as F). I need a formula which will count the instances in which the...

I am sure this has been answered before...but I have one sheet of data that has a number in column A, then a second sheet that has 2 columns, one with a...

How can I tidy up this code as it goes on for 50+ searches ? ' Update_C5&Mgr (Select Columns) Range("A:B").Select Range(Selection,...

How do I create this formula in VBA and use this on multiple cells? I've never worked with this before

Hi, I need to use the following formula =OFFSET('HW - TCO'!B7,0,-1) HW - TCO is reference to another sheet in my excel. the name of the sheet is actually...

Hi, I want to lookup a value, and concatenate the results. Example: Col A; Col B apple; 1 pear; 1 naartjie; 2

Have First Name(Space)Midle Name in a cell - only need First Name. Have been trying LEFT(A1,LEN(A1)-SEARCH((" ",A1)) but the new cell only shows the first...

I want to compare actual values with planned using a simple cell rules. e.g If actual cell value = planned cell value go green and if not red. This works...

I have a spreadsheet and in column D contains Equipment #'s and their description separated by a comma. How can I separate the Equipment #'s into Column...

Hi, I am working on a spead sheet that in D colum has 76.50 this represents 76 seconds and .50 100's of a second I am tring to come up wit a formula that...