I am not sure if this can be done but here is what I am looking for help with I have 2 columns in a spreadsheet that I use to record the date and time that a...

First, thanks in advance for any help. I'm using the NETWORKDAYS function along with the TODAY function to calculate the amount of time that has elapsed for a...

how do you format a cell so that when you enter 1254 the number is displayed as 1,254,000

I am using Excel 2007. I have a large workbook (assembled from many sources) that contained many unused custom cell styles. I was able to delete all of the...

I'm wanting the email a spreadsheet with my color changes. I've tried inserting them into the sheet code but that won't allow any macros to function. Help...

How to copy custom created table styles between workbooks

Hi to all Currently I have DV set whole number -1000 to 1000. I need to add that if cell A1 = "Cat" then whole number should be positve. How do I do...

I have a sheet with 6 columns of dates (K to P). K is the job start date, P is the job end date and the ones inbetween are inbetween dates. It is possible...

I did post a similar question yesterday but it may have been too confusing and I did not get an answer to suit my needs. I have decided to simplify my...

I am trying to use a custom data validation formula to prevent entry in a cell if another cell is blank. If I enter: =ISBLANK($G$51) I get the opposite of...

Hi all, I want to limit the input order using custom validation. My case is as following: From a1 to a10, i want user input one by one in order, so I use...

I want to copy a date field "10/18/2005 8:05" into another column and change it to a number (minutes) so 8:05 (8 hours & 05 minutes) reads as 485 minutes -...

I have a pivot table that is updated daily, but for reporting purposes, I only want to include the last 14 days in my report . I see date filters for this...

A user here wants to key a date in as 112003 and not have to key the slashes. I can create a custom date format that will fill in - for her instead of...

I would like to use a date format that Excel 2000 does not have available. The format is YYYY/MM/DD. Does anyone know if/how I can make this format in...

Does anyone know how to create a custom date format? I want to have the far left column display the date but rather than having each row being a new date;...

Hi there, I am trying to acheive something like the following: ="For the months of: " & Format(MENU!B4-12, "mmm-yyyy") However with no luck. How might I get...

Is there a way to format an Excel date such that - the day of the week appears as a single letter? SMTWTFS or - the month appears as a single letter?...

I need a formula that returns true is the date in cell C1 is in the next 4 weeks. The catch is this week can not count. So, if today is 7 june 05. I need the...

Hi, This is for our timesheets. We have two lists that I'm interested in speeding up: client list, job activity list. Clients are represented by their names...