Formula in a Cell with condition?

Learner7 · #1 07-17-2010, 03:25 AM

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.

ConneXionLost · #2 07-19-2010, 10:10 AM

Hi,

Code:

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

Cheers,

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How can I write the following (whole) formula in a single cell?	Learner7	Excel	1	07-19-2010 10:06 AM
Protect formula in cell?	markg2	Excel	4	05-24-2010 11:50 AM
Moving formula range multiple cells when moving sum over one cell	FraserKitchell	Excel	4	02-26-2010 10:38 AM
Auto-populate an MS Word table cell with text from a diff cell?	dreamrthts	Word Tables	0	03-20-2009 01:49 PM
Retrict Method Condition	markp	Outlook	0	12-22-2005 05:38 PM