How to calculate number of days with two different conditions

[Autin]

To All

I am having a problem in trying to calculate the number of days under two conditions into the same cell.
I have posted below an example of the information all within the same row, but in different columns as noted and what is actually trying to be accomplished.

Cell B date (example:01/07/2013)
Cell D could be "G" or "F"
Cell F date (example:11/29/2012)
Cell I date (example:01/05/2013)
Cell M number of days and location of formula needed (see example below)

to cell M if Cell D is a "G" then the number of days between Cell B and Cell G
BUT
to cell M if Cell D is a "F" then the number of days between Cell G and Cell I

I want to Thank those that help with this problem.

Sincerely

[alansidman]

Assume data is in Row 4, then

=IF(D4="G",B4-G4,IF(D4="F",I4-G4,"")) If cell D4 is neither an F or G, then the formula returns a blank. In your example you had no data in column G.

Tutorial on Nested IF statements
http://www.techonthenet.com/excel/fo.../if_nested.php