|
|
|
|
#1
05-24-2011, 09:27 AM
|
|||
|
|||
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. 
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Need to Create a Resource Driven Schedule | gamer83 | Project | 2 | 05-24-2011 03:56 AM |
 Creating a date box
|
Philip290 | Excel | 5 | 05-11-2011 03:27 AM |
|
A date question
|
markg2 | Excel | 3 | 11-05-2010 02:35 PM |
| new appointment date always reverts back to today's date | msills | Outlook | 0 | 08-24-2007 08:57 AM |
|
Imported message date change to today's date
|
promark | Outlook | 1 | 12-23-2005 07:21 AM |
Windows 7 64bit 
Office 2010 64bit
Hybrid Mode