Thread: [Solved] Date driven value
View Single Post
 
Old 05-24-2011, 09:27 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
Hey macropod! I found a formula that works out except with one minor issue, when the day# is greater than the Friday#.

=IF(ABS((DAY(C$1)-10))<5,45000,"")

Can you help me with my logical issue? For example, if the Friday is the 3rd and the periodic payment date is the 30th, it doesn't work out. I want to use the OR function, but I'm not able to structure it properly.
Reply With Quote