CODEWITHSUNDEEP
excelexcel-formula
Robin Olsson
Robin Olsson

Reputation: 1

Excel - Conditional Date Function

Using Excel, I would like to create a conditional Date formula as follows:

If the Date is Greater than or Equal to January 18, 2013, Enter $220.00 in this cell.

Is this possible to do?

Thanks

Upvotes: 0

Views: 220

Answers (2)

QArea
QArea

Reputation: 4981

Try this: 

 =IF(A1>DATEVALUE("17/1/2012"),220)

Upvotes: 0

barry houdini
barry houdini

Reputation: 46331

If cell A1 holds the date try this formula in another cell

=IF(A1>=DATE(2013,1,18),220,"")

format the formula cell as currency

Upvotes: 4

Related Questions