date and number

Hi Everyone This should be rather simple, any help is appreciated thank you :) In column A i have a dates in order in order, in column B i have either if the day was a "win" or a "lose" In Column C i have a formula for current win streak im looking for a formula to determine given the...

I've been trying to figure out the best way to get data based on a current date and typically use vlookup but it won't allow 12 conditional statements to look at each month. I want to populate based on the current date retrieving from tables from each month assuming the table was extended out...

Hi I'm a little lost here, so hope someone can guide/help me. I having a Sheet1 where I have 7 rows Monday to Sunday and week number 31 to 52. The week numbers i'm getting by the formula AG5 = Weeknumber(Year!B2,2) And then AH5 = AG5 + 1 and so on, up to week number 52. Then I have another...

I would like to have a formula that will show the progress of days in a specific month. Example: On 10 Jan 2017 the formula would create the number 10. The tricky part is I would like it to stay at the total days in the given month when it goes to the next. Example: On 01 Feb 2017 it would...

Hi Everyone, I wanted to know what is the formula to convert "MMM-YY" format date to "DD-MM-YYYY" format. for example, In cell A1 i have a value May-16, now in cell "B1" i need the value as 31/05/2016. similary June-16 as 30/06/2016. The date should last day of the month. Please help me to...

Hello, I want to select the rows based on the date and past it in other sheet. for ex: lets take today's date 24/06/2016. So now select the rows that is < 8 days and >8 days from 24/06/2016 on wards and paste it in the other sheet. Below is pic. Thank You! Regards Wither

Hi guys. I am trying to find a formula that will sum sales up to a specified date, at which point it stops summing. eg. I have 4 rows dated 01/02/16, 08/02/16, 15/02/16, 22/02/16 and so on. If those rows are in column B I want the relevant row in Column C to sum up the figures that are updated...

Hi everyone, First time poster here, appreciate any and all help. I have an excel document that continues to convert dates to numbers, and I have no idea why. For example, 2/2/14 changes automatically to 41672 and 4/4/14 changes automatically to 41733 (left adjusted in the cell). The cells...

I am trying to create an indexing system, that can check and create an index from a number of worksheets and forms as different transactions or events occur, the index number is created by the date formatted "ddmmyyyy" and an indexing integer at the end. example and code below. everything runs...

Hi Everyone, I need VBA help to replace content of a certain column based on multiple criterion. If the value in the Extension Column in Sheet1 is found in the Extension column in Sheet2 AND the Date in Sheet1 equals or falls between Date From and Date To in Sheet2, replace Number in Sheet1...

Hello all, I've got an issue where I've imported a table from a different workbook and all the dates that have been imported are showing the number value of the date (even though the original data is formatted to a date) it also won't let me change the format to a date. It says it's a date in...

Hi I'm having problems with the following formula: <tbody> A B C Date Opened Date Closed Total days to closeout 26/07/2013 13/08/2013 18 26/07/2013 19/08/2013 24 31/07/2013 -41486 01/08/2013 -41487 </tbody> I want to copy the following formula in Column C all the way...

How to get 1st date & last date of a month based on month punched in a cell? Ex: A1=JULY, B1=2013 Answer: C1=01July2013, D1=31July2013 Also, required 01July2013 in separate 8 (or required no.) of cells. Also, required 31July2013 in separate 8 (or required no.) of cells.

Hello, I have recently been given a large spreadsheet from which i need to calculate the number of days between two columns. The problem is they are not displayed in uk date form. The format for the date fields is 20130501 representing the 1st of May 2013. Does anyone know how to produce the...

I'm trying to develop a function to locate a date in a specific column in a spreadsheet (Excel 2010). I've tried lots of variations but still get "Nothing" as a Find result. The Worksheet (Sheet1) has column "B" formatted as "Date". In B2 I have "=NOW()". In B3 to B30 I have "=Bx+1", so each...

I want to have a cell that contains a numeric value that's connected somehow to a date. Is there a way to make a cell that contains a value to be "date specific". Here's what I'm trying to do. I'm making a sheet that is helping me determine inventory quantities at the beginning of each...