Looking for help with If statement
 

Is there a function like the ISBLANK function for dates. I am trying to write
and IF statement formular that works like this:
If the value in A1 is a Date then perform calculation else leave blank.

What is the best way to do this.

Thanks

Looking for help with If statement
 

Please try this will return FALSE if valid date..
=ISERROR(DATE(YEAR(A1),MONTH(A1),DAY(A1)))

If this post helps click Yes
---------------
Jacob Skaria


"Ayo" wrote:

Is there a function like the ISBLANK function for dates. I am trying to write
and IF statement formular that works like this:
If the value in A1 is a Date then perform calculation else leave blank.

What is the best way to do this.

Thanks

Looking for help with If statement
 

I was looking for something in this line:
=If(A1=Date,
SUMPRODUCT(--(Progress!$A$5:$A$1756=$A$5),--(Progress!$D$5:$D$1756=C$3),--(Progress!$E$5:$E$1756=$B5)), "")

"Jacob Skaria" wrote:

Please try this will return FALSE if valid date..
=ISERROR(DATE(YEAR(A1),MONTH(A1),DAY(A1)))

If this post helps click Yes
---------------
Jacob Skaria


"Ayo" wrote:

Is there a function like the ISBLANK function for dates. I am trying to write
and IF statement formular that works like this:
If the value in A1 is a Date then perform calculation else leave blank.

What is the best way to do this.

Thanks

Looking for help with If statement
 

Try here

http://www.mrexcel.com/forum/showthread.php?t=36619

This a formula the will give True False - which you could use

=OR(CELL("format",A1)={"D1","D2","D3","D4","D5"})

Original formula from :

Aladin Akyurek
MrExcel MVP

edvwvw



Ayo wrote:
Is there a function like the ISBLANK function for dates. I am trying to write
and IF statement formular that works like this:
If the value in A1 is a Date then perform calculation else leave blank.

What is the best way to do this.

Thanks

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200904/1

Looking for help with If statement
 

Then just implement Jacob's suggestion, as in:
=IF(ISERROR(DATE(YEAR(A1),MONTH(A1),DAY(A1))),"",
SUMPRODUCT(--(Progress!$A$5:$A$1756=$A$5),--(Progress!$D$5:$D$1756=C$3),--(Progress!$E$5:$E$1756=$B5)))

Regards,
Fred.

"Ayo" wrote in message
...
I was looking for something in this line:
=If(A1=Date,
SUMPRODUCT(--(Progress!$A$5:$A$1756=$A$5),--(Progress!$D$5:$D$1756=C$3),--(Progress!$E$5:$E$1756=$B5)),
"")

"Jacob Skaria" wrote:

Please try this will return FALSE if valid date..
=ISERROR(DATE(YEAR(A1),MONTH(A1),DAY(A1)))

If this post helps click Yes
---------------
Jacob Skaria


"Ayo" wrote:

Is there a function like the ISBLANK function for dates. I am trying to
write
and IF statement formular that works like this:
If the value in A1 is a Date then perform calculation else leave
blank.

What is the best way to do this.

Thanks