SUMIF Formula (I think...)

J

JS

Hi,

I have a workbook (well obviously or I wouldn't be here...), Excel 2003.
One sheet is a running sheet containing a summary of invoices for the month -
one invoice per row. A10 contains the date of the invoice, G10 contains a
code, eg 3, which equals 21days. What I want to do is this: IF G10=3, then
A10 + 21, or IF G10 = 4, then A10 + 30(days) or if G10 = 5 then add 30 days
from End Of Month (have no idea how to display this). I want Column H to
display the due date of payment, and be highligted if past due.

Is this possible? Have been playing around with some formulas, but so far
no joy.
 
J

JS

Hi NBVC,

Thank you so much for your formula, it works perfectly for 3 & 4, however 5
doesn't work - it's returning the #NAME? error.
 
M

Max

You can also use: DATE(YEAR(A10),MONTH(A10)+1,0)
to replace: EOMONTH(A10,0)
in NBVC's expression

btw, do hit the YES's (like the one below) in all responses which help
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
 
J

JS

Hi Max,

Thank you for your response. The formula works, however it's returning the
incorrect date. If the date in column A is say 12/07/09, it returns 31/07/09
when it needs to return 31/08/09. Sorry if I hadn't made that clear.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel How to create a Accounts Receivable to calculate days in which payments against invoice are received 0
sumif formula returns incorrect value 1
What formula do I need? 3
To find due days of debtors 2
passing dates in a conditional sum(if) 2
Sumif and IF ??? 1
sumif formula 2
formula help 5

Top