Is there a function that can determine if a date is even or odd? Thanks!

If column a has a limited # of phone numbers in 1 sheet and in the 2nd sheet I have those numbers embedded with many others as well as additional information...

Yesterday I posted a question about auto filling the date in a field (posted bellow). Well today to my dismay all those dates advanced to todays date. Is there...

Microsoft Excel 2003 I have a list of names for a roster in a single column covering several months. The information is imported from another source (MS...

There is a bug in the help section for function SUMIF. Last line says "Sum of the commissions for property values over 160000 (21,000)" but it should say "Sum...

I am trying to write a formula that will copy a cell or group of cells from one sheet to another based on a null value. Here is the formula I am...

I have excel and I have folders containing excel spreadsheets. I would like to be able to print only the titles of the files contained wihtin an excel folder.

I have created a formula on a timesheet, which I have copied thru to 50 cells, but if there is nothing in one of the cells it copies all of the last cells...

Hi We are currently planning to create some reports and before we start on it we would like to know if excel has any limits on the number of work sheets. We...

I am working in excel and am placing a formula in diferent cells. I would like to be able to convert a column number to the letter representation. such as 1...

I am working on a time sheet for work that is using the excel program. The sheet has clock in and clock out times in several different cells. I am trying to...

And, when I enter "01", for instance, Excel converts the value "01" to "10000000". I'm assuming "FIX" has something to do with this; but I have no idea how...

VLOOKUP issue In the included table, where am I going wrong? Is 4B valued at more than 4A or 4C? How can I get my lookup to work correctly. Jonah

I have 2 worksheets that I need to compare "Part No" and "LCN" to return the "PLSIN" associated with the match between the worksheets of the two data points. ...

Hello, I have a 1000 line sheet that has multiple titles and so on. I like to retrieve the highest salary for a given title. Position titles are not sorted. ...

I have several sheets that I am trying to merge together. Each sheet has a base of the same 6 columns and an unspecified number of variable columns. I am...

First Name Target Attained Indicator Andrew 4B 4 -0.3 Alan 4C 5 0.4 Aisha 4C 5 0.4 Ben 4C 4 -0.6 Bernice 4C 4 -0.6 Lookup table is on the...

My spreadsheet is downloaded as: 006 02 $1.00 006 02 $1.00 006 03 $1.00 006 03 $1.00 007 02 $1.00 007 02 $1.00 007 03 $1.00 007 03 $1.00

I am trying to total up hours worked in a one week time period. I found the noted formula if the total is going to be 24 hours. However, I cannot get an...