Date 1 Date 2
2003-11-13-14.17.16.000000 2003-11-14-16.02.55.000000
2003-11-06-08.14.32.000000 2003-11-06-10.28.03.000000
2003-10-31-13.22.19.000000 2003-11-13-12.14.07.000000
I have 2 fields (Date 1 and Date 2). I need a forumla to calculate the numbers of days...
I have many cells that reference and make calculations from other cells. When these cells have no infomration in them they dislay "#DIV" or "0" or whatever else. I do not want the cells to have anything in them until something is entered.
Is there a way to keep the...
I have about 300 Rows on an EXCEL sheet that I need to print.
I need for each line to print on a seperate page with the headers included. How can this be done?
Name Desc Review Date
Berry asc O 9/01/02
Berry asc V 9/01/01
Berry asc E 9/01/00
Jamie salk V 9/01/02
Jamie salk V 9/01/01
Jamie salk V 9/01/00
Michelle rep U 9/01/02
Michelle rep U...
I have to colums with similar data. Some are the same and some aren't. Colum "A:26" may have the number 987.23 and colum "B:26" may have 987.29...
I need a formula that compare two adjacent cells and flags them by bolding or return a value in a differnt cell if they are...
I've recently used a formula that allowed me to take a start date and coompare it to the current date and it returns the number of TOTAL DAYS.
Is there anyway that I can have it return the total number of months instead of days?
Please advise,
Thanks in advance.
So I have a column with number that range from 0 - 2,
then I have another that has some letters in it.
I want to be able to do something like.
If N# > 1 add the letter "A" to the string in B#
Else add the letter "B"
Example
N B RESULT
1.4 VE AVE
.9...
Hello,
I have a column (H:19,H:76) that assigns the variables AVE, AO, AE, BVE, BO, BE to various people.
1) I want to assign a value to each of the 6 variables
2) Then I want to have a column that does something like:
IF (CELL H# = AO)
THEN (CELL R# = BONUS * .045)
ELSE IF (CELL H# = AE)...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.