Rendering an existing formula to be conditional on dates

[mjohn99]

Greetings,

I have a particular formula that I would like to change based on whether event occurs before or after 365 days.

Currently, cell Z40 is correctly entered as =(365/(D40-C40)*(N40+T40+G40))/(E40*F40)

I would like, however, to make it conditional, so that it is only valid if TODAY() - C40 <= 365.

OTHERWISE, if TODAY() - 40 is > 365, THEN Z40 should equal =(365/(D40-C40)*(O40+U40+G40))/(E40*F40)

Don't want to get this wrong. Any help is appreciated.

Michael

[Ace_XL]

Try

=IF(TODAY()-C40<=365,(365/(D40-C40)*(N40+T40+G40))/(E40*F40),(365/(D40-C40)*(O40+U40+G40))/(E40*F40))

or this shorter version

=365/(D40-C40)*(G40+IF(TODAY()-C40<=365,N40+T40,O40+U40))/(E40*F40)