how to use date in if fxn

R

RAY

I would like to have my condition be a date in my true/false part of my IF
function. Is this possible?
 
T

Tyro

=IF(1>2, DATE(2008,1,1),DATE(2007,2,1))

If 1 is greater than 2, the date of January 1, 2008 is returned. If 1 is not
greater 2 then the date of February 1, 2007 is returned..
Of course the cell containing the formula must be formatted as a date. If
not, you will see a date serial number.

Tyro
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

sumif issues 1
VBA word change keys 0
Macro to Select text from a point given to a specific word 2
vlookup formatting problem 1
Help with MIN fxn please! 2
Dcount -Date Criteria - Won´t find it - 0
Conditional Formatting question.... 1
Display weeks from a Milestone 0

Top