| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
days count between different date format
I try to count the # of days in each row between two columns but each field
has different format. Some cells are in Date Format and some are in Text format. How can I setup a formula to count the number of days? I got the #NUM! when I used =DATEDIF(A1,B1,"D")+1. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
days count between different date format
You need to convert the text format to real dates first.
How do the text dates look like -- Regards, Peo Sjoblom "David" wrote in message ... I try to count the # of days in each row between two columns but each field has different format. Some cells are in Date Format and some are in Text format. How can I setup a formula to count the number of days? I got the #NUM! when I used =DATEDIF(A1,B1,"D")+1. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
days count between different date format
Hi,
In a spare column, use the ISNUMBER() function on the date. Then filter the column to display all FALSE values. Now select the date column and go to Data Text to columns. Select the date format under "Date" radio button. this will convert all the text values to dates. This solution assumes that all the non dates are in one format. -- Regards, Ashsih Mathur Microsoft Excel MVP www.ashishmathur.com "David" wrote in message ... I try to count the # of days in each row between two columns but each field has different format. Some cells are in Date Format and some are in Text format. How can I setup a formula to count the number of days? I got the #NUM! when I used =DATEDIF(A1,B1,"D")+1. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
days count between different date format
the table was received from other party and I am trying to count the # of
days automatical in other column C. Even I format the column A & B to DATE, all still keep in the original format. Like that: ColumnA Column B "1-1-90" 1-30-90 1-2-90 1-30-90 "1-1-90" "1-31-90" I think the data was copied and pasted from other system to the Excel worksheet "Ashish Mathur" wrote: Hi, In a spare column, use the ISNUMBER() function on the date. Then filter the column to display all FALSE values. Now select the date column and go to Data Text to columns. Select the date format under "Date" radio button. this will convert all the text values to dates. This solution assumes that all the non dates are in one format. -- Regards, Ashsih Mathur Microsoft Excel MVP www.ashishmathur.com "David" wrote in message ... I try to count the # of days in each row between two columns but each field has different format. Some cells are in Date Format and some are in Text format. How can I setup a formula to count the number of days? I got the #NUM! when I used =DATEDIF(A1,B1,"D")+1. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count left over days with date | Excel Discussion (Misc queries) | |||
| Date glitch? First 12 days of month format differently than the r | Excel Discussion (Misc queries) | |||
| I want to count days between two dates including start date | Excel Worksheet Functions | |||
| Count number of days between dates BUT IF null to current date | Excel Worksheet Functions | |||
| How do I count the number of days from 1 date to another? | Excel Discussion (Misc queries) | |||
Linear Mode
