Replies

Thanks. That’s exactly what I needed. But where is it documented? It doesn’t show up in the list of available functions. Are there any other undocumented functions?

Thanks. That’s exactly what I needed. But where is it documented? It doesn’t show up in the list of available functions. Are there any other undocumented functions?

OK, I don’t need to use a function at all, just format the cell the way I want it to appear. However, that doesn’t solve my problem. The reason I was trying to use a function was because I am trying to calculate the number of whole months between two dates. The formula =(A1-A2)/(365/12)-0.5 isn’t accurate, as it doesn’t take account of leap years. For example, if the two dates are 3/17/1994 and 11/16/2006, this formula produces the result 152, but the correct result is 151.

OK, I don’t need to use a function at all, just format the cell the way I want it to appear. However, that doesn’t solve my problem. The reason I was trying to use a function was because I am trying to calculate the number of whole months between two dates. The formula =(A1-A2)/(365/12)-0.5 isn’t accurate, as it doesn’t take account of leap years. For example, if the two dates are 3/17/1994 and 11/16/2006, this formula produces the result 152, but the correct result is 151.

OK, but that doesn’t help. I want to display the month as 3 letters (Oct, Jan, etc.). If I format the day column as dd, it displays the date (26, 27, etc.); if I format it as ddd, it displays the day of the week (Mon, Tue, etc.). How do I get the month to display as 3 letters?

OK, but that doesn’t help. I want to display the month as 3 letters (Oct, Jan, etc.). If I format the day column as dd, it displays the date (26, 27, etc.); if I format it as ddd, it displays the day of the week (Mon, Tue, etc.). How do I get the month to display as 3 letters?

If the cell containing the date is formatted as general, it displays the date in serial number format. See the file dates.xls I have posted.

If the cell containing the date is formatted as general, it displays the date in serial number format. See the file dates.xls I have posted.

It’s a real date. See the file dates.xls I have posted

It’s a real date. See the file dates.xls I have posted

OK, here’s a file called dates.xls

OK, here’s a file called dates.xls

I don’t remember what the equivalent was in Word 2000 but in 2002 (XP) you go to Options|Save and uncheck the ‘Prompt to save Normal template’. That’s not a feature that was introduced in XP, and there’s an equivalent setting for Word 2000.

I did get that dialog box, and selected 10 minutes. I still got the prompt for every email. Is this a feature that worked in Office 2000 but got broken in 2002?

I did initiate the process from Outlook, and that is what happened. I selected a contacts folder, selected the contacts I wanted to email and then selected Tools|Mail Merge.