macmomma4
New Member
- Joined
- Jan 7, 2005
- Messages
- 8
I know this is an odd post, but I need to put the following formula into layperson's terms and can't seem to . I need to be able to explain it to a co-worker who isn't the most excel saavy. Can anyone help?
=IF(AND(ISBLANK($I7)=TRUE,ISBLANK($J7)=TRUE),"",IF(AND(ISBLANK($I7)=FALSE,ISBLANK($J7)=TRUE),MAX(0,MIN($AL$6,DATEVALUE("3/31/2005"))-MAX($I7,DATEVALUE("1/1/2005"))+1),MAX(0,MIN($J7,DATEVALUE("3/31/2005"))-MAX($I7,DATEVALUE("1/1/2005"))+1)))
=IF(AND(ISBLANK($I7)=TRUE,ISBLANK($J7)=TRUE),"",IF(AND(ISBLANK($I7)=FALSE,ISBLANK($J7)=TRUE),MAX(0,MIN($AL$6,DATEVALUE("3/31/2005"))-MAX($I7,DATEVALUE("1/1/2005"))+1),MAX(0,MIN($J7,DATEVALUE("3/31/2005"))-MAX($I7,DATEVALUE("1/1/2005"))+1)))