Excel IF

[jamada]

Hi

I have been racking my brains out on this for a almost a month, and am now in need of help!................

IF(D3>=DATE(1991,1,1),"",IF(E3>=DATE(1991,1,1),"")IF(F3="",(IF(E3="",DATEDIF(D3,DATE(1990,12,31),"d"),DATEDIF(E3,DATE(1990,12,31),"d"))),(IF(E3="",DATEDIF(D3,F3,"d"),DATEDIF(E3,F3,"d")))))

I realize that I have "IF" statements within "IF" statements BUT cannot get it to work........... I think I'm close.can anyone help thanks g

 

[Oaktree]

Please explain what you'd like the formula to return

 

[njimack]

Even without knowing what you're trying to achieve, I can see a duplication in your formula.

Replace

IF(D3>=DATE(1991,1,1),"",IF(E3>=DATE(1991,1,1),"")

with

IF(OR(D3>=DATE(1991,1,1),(E3>=DATE(1991,1,1)),"")

 

[jamada]

Columns D E and F have Dates
Column N will be the year 1990 and Column O will 1991 etc etc until 2010


Column D and E are start Dates, Not all have a start date in Column E, so I need to check against that if no strt date in E then use strat date in D.


Column F is an end date .


What I am trying to accomplish is finding out the total amount of days between the start and end date, IF NO end date then assume Dec 31.


In the years columns I only want to report in "days" how many days, of course if in column F their is no end date I want to keep on counting those dates within each year.


End result I am attempting to accomplish, is over a 15 year period how many days experience PER YEAR


Eventually I will create an average when totaling Rows (about 150)

VBA is OK to if it works better, thnaks g

 

[Oaktree]

I'm not too sure where columns N and O come in, but maybe this?

=DATEDIF(IF(E3="",D3,E3),IF(F3="",DATE(N$3,12,31),F3),"d")

 

[jamada]

Column N (the year 1990), will be where the formula resides, then repeated in Col. "O" through "AH"


tks g

 

[jamada]

Ok .......not Ashamed to say NOW I'm not only lost I don't even know where I'm standing!

Formulas look good .....I just can't bring it all together........I know JUST A TINY TINY littl ebit more than how top open up Excel, but everything is self taught through frustrations like this!

HELP!!!!!!!


tk sg