Hello I'm trying to write the date (eg., 21-Mar-05, or any other variation), using contatination within an if statement
Here is a sample
=IF(A1="scenario1","(2) enter the correct post dated process date in the ""PROC"" field"&"  "&"c2","")
where "c2" would contain the date,

I work in a Swedish environment, and would like to use the function Weeknum,
the thing is, that Sweden uses a different way to number our weeks, for
example, the date 2005-01-01, is weeknumber 53, but if I use the function
Weeknum, it computes to weeknum 1. Is there anyone who ...

Using Excel 2003 I'm building a Form Spreadsheet that many dates need to be
entered by users.  Instead of keying each date how do I display a calendar
for spread sheet cell for user to point & click the date they want entered?

I know there is a simple solution to my problem.  The following is my formula:
=COUNT(IF((TEXT(IndexData!$G$5:$G$23309,"yyyymm")="200501")*(IndexData!$A$5:$A$23309="AUT"),AND(IndexData!$I$5:$I$23309<=3,""),IndexData!$I$5:$I$23309))
The formula is not bringing back to the number of ...

How can I set up a drop - down box for a cell.

I am looking for an EXCEL template or formulas to calculate inventory shelf
life by days.  Something like an accounts receivable aging report.  Is this
possible?  If so, how?

I need to be able to calculate the number of hours from beginning of
procedure to end of procedure.  
I download from another system which unfortunately puts the start date in
one column and the time in another.  I currently retype the date/time into a

How do I generate a moving average in a cell - say cell "b4" , i.e.,
"=average(a1:b1:c1)".....and then put it in a macro so when a number is
copied into d1, the formula moves to the adjacent cell c4 and displays
"=average(b1:c1:d1)"?

I have two columns with dates. Column A = Transaction Date and Column B =
Post Date.  Is it possible to use a formula to identify those transactions (
A) that occurred on a weekend?
Thank you!

Like you can in a table in "MS Word". In order to make two columns in one cell.

I have 3 columns: units, numeric grade, and points.
Points are calculated by multiplying units by numeric grade.
Then I divide total points by total units.
Occasionally, I have a non-numeric grade. When that's the case, I wan

I want to write a formula adding a row such as a2+v2+c2 etc.  how do i write
it.

I try to to use 3 critéria in a formula with the Countif function. Actually
two of them represent a bracket.
For the calcul of the bracket I found the good result by using :
=countif(E4:E2337;"<=2")-countif(E4:E2337;"<=5")

I am trying to add up the number of checked checkboxes in a column. Is there
a formula that will look at how many are checked vs how many are unchecked?

How can I separate sub-totaled data from the detail it was created from. For
example, if I want to sort the sub-totaled data, the detail is included in
the sort.
I have similar problems when trying to do other things with sub-totaled data