# How I Can Minus Number From A Month?

Dec 2, 2008
In an excel file i have two fields,

Month to Start - is a combobox with 12 months, next is

Month to go back - is a textbox, here specifying number of months to go back.I need to store month names by minus the existing month - number in a textbox

eg: if Month to Start is 'September' and Month to go back is 2, then what i need is September & August in an array or separate variables.

How I can minus number from a month?

View 9 Replies
ADVERTISEMENT
Nov 20, 2008

I am trying to write a formula which takes todays date and goes back 1 month.

Eg Today = 20/11/2008, however my formula would give me 20/10/2008

View 8 Replies
View Related
Feb 8, 2012

I have a formula to find the number of Mondays between 2 dates.

=SUMPRODUCT(--(TEXT(ROW(INDIRECT(E2&":"&F2)),"DDD")="THU"))

I now need to add in the variable of holidays and other days off. This is where I am loss. I do have a list of the weekdays that we did have class and a list of when we didn't

View 9 Replies
View Related
Mar 8, 2014

I am having trouble setting up my cycle count spread sheet. For instance if my starting number is 1000 and when it reaches 0 or below it starts to count in minus when I just want it to automatically reset to 1000

View 3 Replies
View Related
Feb 14, 2013

I have a column of numbers which have the - sign at the back end of the number instead of the front. What would be the easiest way to turn that into a negative number without manually keying each one?

View 4 Replies
View Related
Jan 28, 2010

I have a spreadsheet that is now a yeare old with 5000 rows and is now going into the 2nd year

Column A is for date input and the same date can be repeated several tumes :-

1 Jan 09

1 Jan 09

1 Jan 09

1 Jan 09

2 Jan 09

2 Jan 09

3 Jan 09

3 Jan 09

3 Jan 09

Sometimes there are all 30 /31 days but normally not .

I need to find the last ocurance of the last date used for each month and then use the cell number to calculate the column totals for that month.

View 9 Replies
View Related
Feb 16, 2012

I am trying to add a dynamic date rang to the heading of a table. I can find the earliest and latest dates, and want to concatenate them in the heading...

January 1 2012 to January 31 2012

The day and year (and the other bits) are easy, but is there an easy way to convert 1 to January, without going through a vlookup.

View 14 Replies
View Related
Nov 12, 2009

I have forumlas that will look at this cell and take action of the month in a different cell is either 1 month greater (Frontmonth+1) or less (Frontmonth-1) than "Frontmonth". As we approach December I'm realizing that logic will breadown since the FrontMonth+1 would be 13, not 1 (January)

Is there a way to get excel to add 1 month to just the month number so that if Frontmonth = 12, Frontmonth+1 would return 1, not 13?

View 9 Replies
View Related
Nov 15, 2008

I was wondering if anyone knows how I could enter a date in one cell, then another date in a second cell and in a third cell have it have it so it minuses the first date from the second and calculates the difference outputted in number of days.

Example: 04/31/08 - 04/01/08 = 30 (days)

View 2 Replies
View Related
Mar 14, 2014

I need a formula that will calucalte the monthly total based on the following conditions:

Col A = Yearly Cost

Col B = The number of the month when the costs are starting (1=Jan etc)

Col C = The duration or the number of months for which the costs are to spread

Col D is Year 2013 with the months across columns D-O. Row 1 above those columns shows the month's corresponding number.

Right now I have =IF($B3<=D$1,$A3/$C3,0) however if my start month is 1 and my duration is 5, I need the costs to stop after May. I've attached a sample file. Calculate based on start month and duration.xlsx

View 3 Replies
View Related
Dec 23, 2008

I m trying to write a formula for my financial model. If anyone can take a stab at a solution. I'm trying to write a formula that will equally distribute revenue either over the next 1 month, 2 month or 3 month period depending on size of the deal.

Details:

Sales will fit in 1 of 3 categories. Less than 25k; between 25k & 100k; greater than 100k.

- if under $25K, recognize in next month (month N+ 1)

- $25K-100K, recognize in two equal parts in months N + 1 and N + 2

- over $100K, recognize in three equal parts over 3 months

N + 1, N + 2, N + 3 ...

View 4 Replies
View Related
Jan 20, 2009

I have number in cell (A1) = 100. when I enter number in any cell of column(B) for example (B1)=10. then in cell (C1) the result of (A1) - (B1) = (90) and if I add in cell (B2)=10 then in cell (C1) the result of (A1) - (B1+B2) = 80 .accumulatively in cell (C1). and any number in column (B), the result will be (A1) minus any number in column(B) accumulated in (C1)

second question

I have number in cell (A1) = 100. when I enter number at cell (B1) = 10 then the result would be in the adjacent cell (C1) = (A1) - ( B1) = 90 and If I enter a new number in cell (B2) = 10 then the result would be in the adjacent cell (C2) = (A1) - (B1+B2) = 80 and If I enter a new number in cell (B3) = 10 then the result would be in the adjacent cell (C3) = (A1) - (B1+B2+B3) = 70 and so on. I want the result to be add automatically to adjacent cell in column (C)

View 3 Replies
View Related
Jan 15, 2013

I am trying to convert the name of a month to a number but there is a slight issue with using my normal method of TEXT("1/"&A1&"/2013","mmm")

I am trying to create a dynamic table which if you change 1 value for the month, it changes others

so my data looks like so,

Jan

Feb

Mar

Apr

May <---- this is the value which is chosen

The problem is when I select the month "January", it assigns the value of the above cell as 1/0/2013 which is not a date when in fact I want to set it as "December".

View 4 Replies
View Related
Jan 11, 2014

I have a Work Log that i would like to be able to analyse, in particular the number of requests submitted per month, The data in the work log looks this this: -

ClientPosition Para-plannerAdvice RequiredDate Required ByMy CommentsReceived by Paraplanning

BurgessCompletedPetePP transfer to GPP 21-Jan-13

Its the received by paraplanning heading date, i want Excel to be able to tell me how many reqeusts were recieved in Jan, Feb, Mar etc. I've tried =countif but that does not do what i need it to, just get an error.

View 4 Replies
View Related
Mar 26, 2008

I want to use a formula to calculate what week number in the month it is (i.e 1 to 6) from a particular date.

I know how to calculate this on an annual basis (i.e. 1 to 52) but not within the month.

This is what I have so far...

=IF(OR(D58=1, D58>=D57), ROUNDUP(DAY(D61)/7,0),ROUNDUP(DAY(D61)/7,0)+1)

d58 is a Weeday formula looking at d61 which is the date i want to look at. d57 is the weekday number of the first day of the month in cell d61.

View 13 Replies
View Related
Feb 20, 2012

I want total in cell A3 based on the month number in A1, example given below.

2nd example if I put 5 in A1 the total should be 2500 in cell A3.

3ResultJanFebMarAprMayJun9002003004001000600800

View 2 Replies
View Related
May 12, 2014

I need formula to change the the date to number of months. Example : May or 1-5-2014 to be changed to days like this = 31.

View 4 Replies
View Related
Jan 9, 2007

I have a spreadsheet with column B being the date when a staff joined the company; column C being the date when the staff left the company. If I want to set a formular in column D to calculate just the number of month had a staff been working in the company, how should I set?

e.g any day joined in Aug 05 and left in Sep 05 will be counted as 1 month

View 9 Replies
View Related
Apr 9, 2009

I just need to enter no. of sundays in a month against the month column for five years. Is there any way to get it by using formula?

View 9 Replies
View Related
Dec 30, 2003

Im trying to use the equivilent of: =DAY(DATE(YEAR(H5),MONTH(H5)+1,0)) in vba. but i am having trouble with the use proper parenthesis.

basically the above will work in an excel workbook and return the number of days in a month. thats all i really need. so if there is an easier way, which im sure there is, then im up for it...

View 9 Replies
View Related
Apr 18, 2008

I want to assign a number or a letter to cells that are similar to eachother. For example if there are 3 different dates that are in the same month I want a latter A or number 1 in the cell next to each of them...and so on.

ColumnA

03/15/2008

03/25/2008

03/29/2008

04/02/2008

04/16/2008

I want:

ColumnA....................ColumnB

03/15/2008................A (or 1)

03/25/2008................A (or 1)

03/29/2008................A (or 1)

04/02/2008................B (or 2)

04/16/2008................B (or 2)

View 2 Replies
View Related
Jul 6, 2012

I have collumn with different dates. I would like to count number of date with specific month in them (for example "june"). I tried it with if function, but something is missing.

Example of data:

1.6.2012

3.6.2012

9.6.2012

30.6.2012

[Code]...

My function: =SUMPRODUCT(IF(A1:A9;IF(MONTH(A1:A9)=6;1;0))) what shoud I correct or of better function?

View 9 Replies
View Related
Jun 11, 2014

how can convert number data to Month and year?

I have data is 27.03.2014 and would like to change this value is Mar-2014.

which formula should be work?

View 9 Replies
View Related
Nov 15, 2013

I have week numbers from 1 to 52, now i want to get which week number will falls in which month, is there any formula in excel

for eg. Week 01 - 05 will fall in January month (2014), likewise..

View 1 Replies
View Related
May 8, 2007

I have a spreadsheet that users are filling in using a userform. Due to the fact that some data may be pre/post dated for entry I am trying to find a way that I can count the number of records per month.

What I have been trying to use (with no luck) is COUNTIF:

View 14 Replies
View Related
Jan 26, 2009

I'm building a budget model, and I need to figure out a way (for a more accurate budget) how to count the number of fridays (or thursdays, etc.)

in A1 is the day i need to count: Friday

in B1 is the Month/Year : Jan - 09

in C1 is the next Month/Year: Feb - 09

etc.

There are 5 Friday in Jan and 4 in Feb.

View 5 Replies
View Related
Nov 14, 2011

I am trying to count the number of dates in November - is there a Countif function or Sumproduct function that would return the number of dates in November?

BroadwayCombined

H3411/4/20113511/4/20113611/4/20113711/3/20113811/3/20113911/3/20114011/3/20114111/3/2011

4211/3/20114311/3/20114411/2/20114511/2/20114611/1/20114711/1/20114811/1/20114910/31/2011

5010/31/20115110/31/20115210/31/20115310/31/20115410/31/20115510/31/20115610/28/2011

5710/28/20115810/28/20115910/28/20116010/28/20116110/28/20116210/28/20116310/27/2011

View 6 Replies
View Related
Jun 15, 2012

I have a month and year entered in A2 in the format "mmm-yy". In B2 i need a formula which counts the number of mondays in that month.

View 5 Replies
View Related
Apr 18, 2013

What is the formula to convert the month in a cell (02-Jan-13) to a number (1 in this case).

View 2 Replies
View Related
Jan 13, 2014

In cell A1 I have a date 1/1/14

I need to get the number of business days for the month that is entered in the cell. I tried NETWORKDAY formula but needs a start and end date.

View 3 Replies
View Related