I am trying to covert Julian dates to calendar date and am using the formula
=DATE(INT(A1/1000),1,MOD(A1,1000)). I am getting the date but the ytear
- Dec 18 Mon 2006 20:34
julian dates
- Dec 18 Mon 2006 20:34
Need help with quot;ifquot; function in Excel
I am trying to set up a spreadsheet and Need to put in the following function:
- Dec 18 Mon 2006 20:34
Need to track cells that haven't been updated
- Dec 18 Mon 2006 20:34
Count Occurances of String in a Column?
I need to count the occurrence of a string that would be contained in text in a column.
For example, in column J, starting at cell 1,
- Dec 18 Mon 2006 20:34
SUMIF with 2 conditions
I am trying to use SUMIf with 2 conditions, I see someone else asked this
question before but I still can't get it to return anything other than #Value!
- Dec 18 Mon 2006 20:34
255 Character Limit
I am doing a vlookup command and am it is only returning the first 255
characters. How can I make it return them all?
- Dec 18 Mon 2006 20:34
Is there a formula which will print the sheet name in Excel?
I want to do a lookup using a list of sheet names in a workbook. For example
I want to lookup something in 'Sheet1' and refer to a cell.
- Dec 18 Mon 2006 20:34
#DIV/0! message
- Dec 18 Mon 2006 20:34
weird!!! verry, verry , verry
blah blah blah blah blah
- Dec 18 Mon 2006 20:34
Vlookup formula
How do I add several $ amounts using the same vlookup reference like quot;data?quot;
Is there a way to add a sum formula in the field?

