Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
If I had a cell that contains the following:
Delivered 11/24 Is there some way I can tell another cell to subtract just the date from another date? For instance, if the other cell has 10/25 in it, I want to use a datedif function to tell me the number of days between the two dates (i.e. datedif(a1,a2,"d"). A1 is the cell with 10/25 in it, and a2 is the cell with delivered 11/24 in it. I need a formula in place of a2 that will look past the word delivered and retrieve the date so it can complete the formula. Any ideas? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
date format within a cell containing a formula | Excel Discussion (Misc queries) | |||
Formula with text and reference to a date cell | Excel Discussion (Misc queries) | |||
How would I change a date cell to decrease it by business days? | Excel Discussion (Misc queries) | |||
Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
Combined date time cell to separate date & time components | Excel Discussion (Misc queries) |