Excel 2007 : How to write a formula in a cell as per the following condition?

[LearnerEXL]

Hi,

How to write a formula in a cell as per the following condition?

Cell E10 = Start Date
Cell F10 = End Date
Cell H10 = Current Date

If StartDate (E10) is less or equal to CurrentDate (H10) then
=SUM(H10-E10+1)
Else
=SUM(H10-F10+1)

I need to write this formula in Cell J10.

Please help.

[zbor]

This?

=IF(E10<=H10, H10-E10+1, H10-F10+1)

Where in H10 you have =TODAY()

[LearnerEXL]

This?

=IF(E10<=H10, H10-E10+1, F10-E10+1)

Where in H10 you have =TODAY()

Thanks for the help. It accepts the first condition (Though the current date is higher than End Date) where it should accept the second condition.

Please try to resolve my problem

Thanks.

[zbor]

Try:

=IF(H10>F10, F10-E10+1, H10-E10+1)

[LearnerEXL]

[QUOTE=zbor;2345613]Try:

It is okay now. Problem fixed.

Thanks.