| 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. |
| 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) | |||
Threaded Mode
