Excel Formula - If Date Exists

[Iceshade]

Hi All,

Seeking some help please - generally not too bad with formulas but this one has me stumped and not even sure if it's possible?

What I am trying to work out is, for a calculation that requires a date do the following:
If a Date exists in Column H, use that date, otherwise use the date in Column F.

Example: =DAYS360($B$1,H5,FALSE)/90

Where H5 would be replaced with F5 in the formula if a date is present in H5. If it's blank, then use F5.

Any guidance here would be great, been on this for a few days now.

 

[Peter_SSs]

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Is this what you mean?

=DAYS360($B$1,IF(H5="",F5,H5),FALSE)/90

 

[Iceshade]

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Is this what you mean?

=DAYS360($B$1,IF(H5="",F5,H5),FALSE)/90

This was precisely what I was after, thank you so much and thank for the tip - it has been a long while since I visited Mr Excel ! I'll update my Excel version

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.