february

Hi all first of many posts to come here :) . I am trying to write a formula that looks at between dates but ignores the year. For example, if a birthday is between the first of January and the thirteenth of February, the year is irrelevant as it can be any year. Bearing in mind dates of birth...

Hi, I have set up a workbook to record flexi-time earned and taken. Any outstanding earned flexi-time can be carried over to the next month, but only for one month, so if you have a balance of, say, one hour that you earned in January, you can use it in February, but if it's still outstanding...

Good Morning All! I hope I have an easy one for you this morning. I've got about 96k rows of policy numbers and 12 columns starting in column B (Jan-Dec). If a policyholder called within that month it displays how many times they called. I'm not concerned with how many calls they made, only...

Hello Dear, i use the below formula to get the count number of the specific cells based on month which are exist on the E column, it works correctly but while it face any cell that contains formula without result it will be (#Value) please your help to avoid this and only consider the dates and...

Thanks to assistance in this forum, I now understand how to easily created a pivot table that shows months as columns. What I am now stuck on is to show multiple rows correctly. For example, I now have: Merchant Amount Sold for Januay Amount Sold for February etc What...

Hi all, I have a pivot table connected to a tabular model. I have row groups going down by calendar granularity: year, month, day. When I click on, say, the February under year 2017, the pivot table expands February for ALL years. How can I set things up so this behavior doesn't occur? So that...

Hello, I want to write a formula for when I update a "Reference" Sheet the letter i type in refers to the columns For example February is column: A March is column : B So in the month of February I want the cells to reference column A, but in March I want it to reference Column B. The...

Hi guys! Need some help regarding this matter. I have something like this data in a table: <tbody> Column A Column B Column C Column D BP January Item A 56756 BP January Item B 4353 BP February Item A 235 BP February Item B 67457 BP March Item A 4577 Expenses January Item A 3452...

I have a spreadsheet that contains dally sales in column K with the dates in column F. What I need is to get a MTD sum of sales and a YTD sum of sales based off the date, which will be in a separate sheet, cell C3. What I am thinking is a VLookup formula using the date in cell C3 as a...

I am creating a new log book for our company and I want to have the 'calibration due date' modify automatically depending on two indicators (can't think of a better term). So I want A3 to change it's date depending on: A1's text (Gauge,Fork lift....) A2's date (calibration date) My hope is...

All, I have a drop down of dates and then a sumif based on the date. It works for every date but February. Any thoughts?

I have 38 sections identical to this (Below) and I am trying to collect all the m's for a particular month in this case November the 1st. Is this possible as Countif(s), Sumif(s), sumproduct, index and match do not work please advise? <colgroup><col><col span="26"><col><col...

Good morning! I have a list of dates in Excel that I would like to highlight in a calendar. Ex) January 1, 2015 January 29, 2015 February 9, 2015 March 12, 2015 March 13, 2015 April 1, 2015 February 15, 2016 (list goes on - there are approx. 600 dates on my list) Does Excel have a calendar...

Hello All My question this afternoon, Is there an alternate way to average December January & February The formula I am using is ={SUM(SUMIFS($B$5:$B$16,$A$5:$A$16,{"December","January","February"}))/SUM(COUNTIFS($A$5:$A$16,{"December","January","February"}))} <tbody> January 25...

Hi Having a spot of bother with DATEDIF. I'm trying to count the number of full months between two given dates. DATEDIF was doing just fine until I got to February. I'm using =DATEDIF(Start Date,End Date,"m") and getting the following ... <TBODY> Start Date End Date DATEDIF result...