| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Between Function
=IF(ISBLANK(C6),"0",IF(($C6-$A$4)<=14,"Current",IF(($C6-$A$4)<14,$C6-$A$4))) I have the above formula. I need the first <=14 to evaluate the difference in dates. if the date is between 0 and 14 days, it must say current, if it is anything other than that, or blank, it must shows the days negative. Any assistance would be greatly appreciated. Thanks in advance. -- techiemom60 ------------------------------------------------------------------------ techiemom60's Profile: http://www.excelforum.com/member.php...o&userid=20124 View this thread: http://www.excelforum.com/showthread...hreadid=542238 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating a Custom Excel Function to Calculate Gini Coefficients | Excel Worksheet Functions | |||
| Date & Time | New Users to Excel | |||
| Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
| Conversion | Excel Worksheet Functions | |||
| HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions | |||
Threaded Mode
