Nov 22, 2003 · I am trying to write a formula in excel that will convert a date to the 1st of the month following 30 days. Can anyone help me?

Mar 20, 2008 · I need to use VBA to convert a field in an imported table from a text data type to a date/time data type. Any suggestions greatly are appreciated.

Mar 1, 2013 · Hi, How could I convert the date and time (for example '15.02.2013 19:58:50' ) in 2 (or more) decimal number?

Jun 11, 2002 · I'm doimg a macro , in a range of cells i need to convert the format of the cell, the format taht i want is Date: dd-mmm-yyyy but my problem is i can't convert the month in font …

Jun 5, 2012 · Hello, I am trying to update an Excel cell with a date using the script below which works fine. I need to read the Excel cell from another program but the program is ignoring the …

Dec 9, 2002 · Datepart returns an integer value. It won't have a leading zero. You can always convert the integer to a character string and add the leading zero. Here is one method. replace …

Feb 17, 2011 · Below is the code I am currently using: DATENAME(Month, DATEADD(Month, Month - 1, 0)) AS MonthName This gives me the Month as January, I need to abbreviate that …

Dec 23, 2008 · I want to be able to convert those 2 cells to 1 unique number. I want this as i have to create a new sheet based on startdate/starttime - enddate/endtime, for example all rows …

Sep 23, 2003 · Index is the file with .ndx extension. You can try to go to Excel, File->Open, set FileTypes to dBase (.dbf), and try to open the tables that you have. Chances are, you will be …

Dec 9, 2013 · I currently receive 834 Benefit Enrollment files each week that need to be compared. I canview the data using a parser or EDI notepad, but I need to compare large …