Jan25,000.00 Feb50,000.00 March30,000.00 Mar95,000.00 Apr65,000.00 April800,000.00 May50,000.00 Jun20,000.00 May300,000.00 Jul20,000.00 Aug30,000.00 June20,000.00 YTD1,505,000.00 Thread0 > 10000006%1000001 > 1500000011%>1500000015%
View 9 Replies
I am trying to add 6 months to a particular date. e.g. April 15 + 6 months = October 15. If it falls on a weekend, it should give the next weekday, ie. October 16. I used the following formula but not sure what is wrong: =IF(WEEKDAY(DATE(YEAR(B4),MONTH(B4)+6,DAY(B4))=6,(DATE(YEAR(B4),MONTH(B4)+6,DAY(B4)+2),IF(WEEKDAY(DATE(YEAR(B4),MONTH(B4)+6,DAY(B4)=7,(DATE(YEAR(B4),MONTH(B4)+6,DAY(B4)+1),(DATE(YEAR(B4),MONTH(B4)+6,DAY(B4)))
View 2 Replies View RelatedI am looking for the easiest way for my worksheet to perform the following:
My 1st sheet (Sheet1) has columns A-C
In Column "A" there is a Cust # call it "P200"
In column "B" I have an invoice amount of $500.00
In column "C" -In this case, I need this field to calculate 15% of the amount in column "B"....and return the result of $75.00 (however, this 15% figure will vary based on data looked up in (Sheet2)
ie... in (Sheet2)
Column "A" will list all cust #'s that my company has - A1=P100, A2=P105, A3=P125, A4=P127, A5=P200 etc....
Column "B" has each respective discount amount for that customer by %... B1=10%, B2=10%, B3=12%, B4=20%, B5=15%
So the macro I need for (Sheet1- column C) will need to search "Sheet2" column "A" to find the "P200" out of the long list and then take the corresponding % amount in column "B" (in this case it's 15%) and use this figure in (Sheet 1) to perform the calc.
