Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Here is the start of a formula I need for document tracking. The first part
works, of course, but I also need to figure out how to get the second condition to work: =IF(E2="","",DAYS360(E2,TODAY())), IF(H2=???????, DAYS360(H2, E2)) This is what it needs to do: If E2 has a date in it, I need it to calculate the DAYS360 function as above, if there's nothing, I need it to leave the cell blank (that part of the formula is functional) However, it will continue doing that calculation forever because "tomorrow never comes," right?! HAHA. So, I need it to perform a different DAYS360 function if cell H2 has a date in it (the only thing that will go in it). I hope this makes sense! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to convert cell formula functions to code functions | Excel Discussion (Misc queries) | |||
efficiency: database functions vs. math functions vs. array formula | Excel Discussion (Misc queries) | |||
Conditional functions | Excel Worksheet Functions | |||
Multiple FIND functions in Conditional Formatting | Excel Worksheet Functions | |||
conditional functions | Excel Worksheet Functions |