Thread: [Solved] Date driven value
View Single Post
 
Old 05-24-2011, 09:44 AM
ronocoo ronocoo is offline Windows 7 64bit Office 2010 64bit
Novice
  
Join Date: May 2011
Posts: 5
ronocoo is on a distinguished road
Default
Okay, this is the formula I came up with.

=IF(ABS((DAY(C$1)-$I19))>25,$J19,IF(ABS((DAY(C$1)-$I19))<5,$J19,""))

Can you help me simplify it? I'd like to combine finding >25 or <5.
Reply With Quote