Previous Topic Next Topic

Excel If statement with date condition

Closed
Glynis - Jan 16, 2017 at 03:19 PM
 Blocked Profile - Jan 16, 2017 at 03:23 PM
Hello,

=IF(I20=0,0,IF(I20-M20-P20-'Rate '!$D$9<0,(I20-M20-P20-'Rate '!$D$9)*-'Rate '!$D$5,))
The function above is calculating a I-Tax Refund... However I would like to incorporate a date condition, because one cannot get a Income Tax refund and the start of the year...so how do i write the function so that the date is taken into consideration?

1 response

Answer 1 / 1
Blocked Profile
Jan 16, 2017 at 03:23 PM
Date for what? It is just another logic check in one of your true or false statements, as in:
=if(i20=0,0,if(i21>DATEVALUE("1/1/2017"),"YES","NO"))

Try that!
1

Similar discussions

How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses
Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response