Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Warrior Pope
 
Posts: n/a
Default Formula with date constraints

Could use some help with the following:

I created a spreadsheet to track payments made to contractors. In this
spreadsheet I have a simple formula that tells when the payment has to be
made based on the date it was rec'd from the contractor and adding on the
payment terms.

Now what I have to do is add in some date constraints. Our paying office
only processes payments between certain windows during the month. Lets say
that for this month the payment window closes Jan 27th to Feb 2nd. What I
need to do is if after someone enters the date the payment is rec'd and the
14 days is added for the payment terms, should the date the payment is made
end up falling within the payment black-out period (Jan 27th to Feb 2nd), I
then need excel to adjust the must be paid by date to 3 days prior to the
black-out period.

Hope this makes sense....I've tried a whole bunch of different things and
have looked online at several sites with no luck. Would SERIOUSLY appreciate
it if someone can help me!

Thanks!
  #2   Report Post  
Jason Morin
 
Posts: n/a
Default

See my response in .Misc.

Jason

-----Original Message-----
Could use some help with the following:

I created a spreadsheet to track payments made to

contractors. In this
spreadsheet I have a simple formula that tells when the

payment has to be
made based on the date it was rec'd from the contractor

and adding on the
payment terms.

Now what I have to do is add in some date constraints.

Our paying office
only processes payments between certain windows during

the month. Lets say
that for this month the payment window closes Jan 27th

to Feb 2nd. What I
need to do is if after someone enters the date the

payment is rec'd and the
14 days is added for the payment terms, should the date

the payment is made
end up falling within the payment black-out period (Jan

27th to Feb 2nd), I
then need excel to adjust the must be paid by date to 3

days prior to the
black-out period.

Hope this makes sense....I've tried a whole bunch of

different things and
have looked online at several sites with no luck. Would

SERIOUSLY appreciate
it if someone can help me!

Thanks!
.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel formula with date constraints Warrior Pope Excel Discussion (Misc queries) 3 January 28th 05 04:08 PM
Date Formula Robyn Bellanger Excel Discussion (Misc queries) 2 December 17th 04 08:25 PM
Formula to determine a future date based on criteria David Excel Worksheet Functions 2 December 15th 04 08:51 PM
Need help troubleshooting an array formula XLXP on Win2K KR Excel Worksheet Functions 1 December 13th 04 08:41 PM
How do I add a date formula to a cell but hide the contents with . Emzy Wemzy Excel Discussion (Misc queries) 2 December 12th 04 02:48 PM


All times are GMT +1. The time now is 02:46 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"