A
Andrew
Hello all ...
I have this formula that gives me a date 10 month in the future based on the
date in M3:
=IF(E3="","",IF(M3="",DATE(YEAR(E3),MONTH(E3)+10,DAY(E3)),DATE(YEAR(M3),MONTH(M3)+10,DAY(M3))))
.... however I want to add 2 other columns/cells so that instead of only
having one date to refer to, I would have dates in M3, N3 and O3. M3, if it
has an entry, will always have the oldest date. I want to only use the most
recent date from the range.
For instance M3 may have 23/08/2009, N3 may have 1/9/2009 and O3 may have
6/10/2010. I only want the formula to take the most recent date being in O3.
Any thoughts please. Thank you.
I have this formula that gives me a date 10 month in the future based on the
date in M3:
=IF(E3="","",IF(M3="",DATE(YEAR(E3),MONTH(E3)+10,DAY(E3)),DATE(YEAR(M3),MONTH(M3)+10,DAY(M3))))
.... however I want to add 2 other columns/cells so that instead of only
having one date to refer to, I would have dates in M3, N3 and O3. M3, if it
has an entry, will always have the oldest date. I want to only use the most
recent date from the range.
For instance M3 may have 23/08/2009, N3 may have 1/9/2009 and O3 may have
6/10/2010. I only want the formula to take the most recent date being in O3.
Any thoughts please. Thank you.