Is it possible to create a formula which will count the number of days in a cell which also contains text? For example the cell contains the following information
Interest Accrual 07/07/2009 to 05/08/2009
The formula would return 30 (there are 30 days from 07/07/2009 to 05/08/2009).
Thanking you in advance
Bookmarks