Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Payment terms function
I have customers that have their own payment terms, for example they will pay
on the following monday after 33 days of the invoice date. I have figured out how to determine the date they will be due after 33 days, but can I get it to give me the date of the Monday after the 33 days? |
#2
|
|||
|
|||
With the invoice date in A1 try:
=A1+33-WEEKDAY(A1+33,3) HTH Sandy -- to e-mail direct replace @mailintor.com with @tiscali.co.uk "Tina" wrote in message ... I have customers that have their own payment terms, for example they will pay on the following monday after 33 days of the invoice date. I have figured out how to determine the date they will be due after 33 days, but can I get it to give me the date of the Monday after the 33 days? |
#3
|
|||
|
|||
=CHOOSE(WEEKDAY(A1+33,1),1,0,6,5,4,3,2)+A1+33
"Tina" wrote in message ... I have customers that have their own payment terms, for example they will pay on the following monday after 33 days of the invoice date. I have figured out how to determine the date they will be due after 33 days, but can I get it to give me the date of the Monday after the 33 days? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I cant use englisch function names in a swedich version of excel | Excel Discussion (Misc queries) | |||
Find a Function to use accross different worksheets | Excel Worksheet Functions | |||
change function variable prompts?? | Excel Worksheet Functions | |||
Counting Function Dilemma | Excel Worksheet Functions | |||
need to save values from a function before it changes | Excel Worksheet Functions |