Thread: [Solved] Formula in a Cell with condition?
View Single Post
 
Old 07-17-2010, 03:25 AM
Learner7 Learner7 is offline Windows XP Office 2007
Advanced Beginner
  
Join Date: May 2010
Posts: 51
Learner7 is on a distinguished road
Default Formula in a Cell with condition?
Hi,

How to write the 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.
Reply With Quote