What I have is
D3 Which has a start date
E3 Might (not always) have a start date earliar than that of D3
G3 Might (not always) have an end date, if No end date then calculate to the end of the year (December 31, 1991)
In short the OLDEST start date until an end date, and if no end date assume Dec 31/91
I will insert the formula in M3
The end result is to determine the TOTAL amount of days,
=IF(OR(YEAR($D3)=1991,YEAR($E3)=1991),"",IF($G3="",IF($E3="",DATEDIF($D3,DATE(1991,12,31),"d"),DATEDIF($E3,DATE(1991,12,31),"d")),IF($E3="",DATEDIF($D3,$G3,"d"),DATEDIF($E3,$G3,"d"))))
its been breakin my heart for 3 weeks and I am only slowly finding out how to do it!
Tks g
[/u]
D3 Which has a start date
E3 Might (not always) have a start date earliar than that of D3
G3 Might (not always) have an end date, if No end date then calculate to the end of the year (December 31, 1991)
In short the OLDEST start date until an end date, and if no end date assume Dec 31/91
I will insert the formula in M3
The end result is to determine the TOTAL amount of days,
=IF(OR(YEAR($D3)=1991,YEAR($E3)=1991),"",IF($G3="",IF($E3="",DATEDIF($D3,DATE(1991,12,31),"d"),DATEDIF($E3,DATE(1991,12,31),"d")),IF($E3="",DATEDIF($D3,$G3,"d"),DATEDIF($E3,$G3,"d"))))
its been breakin my heart for 3 weeks and I am only slowly finding out how to do it!
Tks g
[/u]