text & date

Hi Experts Just now I encountered a strange situation. The TEXT function is not returning correct month name from a date. See Column D & E below 👇 I must be doing something really silly and ignoring something basic to get into this trouble. Please help Thanks in Advance...

Hi, This is for Google Sheets. I need a formula that returns the text when using a sum max for a number by date. In the below example, AA02 is the answer for January 2023 b/c 4,120 is the max sum (3,995 + 125). cell A1 1/31/2023 2/28/2023 Result AA02 CCC data set Month Year...

I want to calculate the ages of the people in a data set. Unfortunately, their birth dates are plain text values, "1 August 2000". I've tried a bunch of things, but can't work it out. I want to convert the values from "1 August 2000" to its numerical equivalent, like "1/8/2000". So that I can...

Hi I have the following table that contains everything in one cell. I want to extract the last date entered in that cell and size in the formate of (00/00"). That two columns should be added to the original table similar to pic below.

Greetings Excel Community, I have numbers formatted in the following Text or general format: 20221026.. I am trying to format it as mm/dd/yyyy.... I have used a formula as follows but it is not generating the correct output: Formula is =DATE(LEFT(G2|4)|MID(G2|5|3)|RIGHT(G2|2)). I am including...

I am trying to create a nested IF statement to look at a cell and do 3 things: 1. look to see if cell is blank, if so leave blank, 2. date in cell- todays date is < 30 print" DUE" in cell. 3. look to see if cell has NA typed in the cell, if so leave blank My code works in terms of the...

Hi, I am trying to set up a formula that adds 30 days (payment due) to the date on the invoice being sent. I have being able to create the formula that references the invoice date but I can't seem to add on the extra bit that adds on the 30 additional days. ="Due Date for Payment...

Hi, I think this is probably a simple fix but for the life of me I can not work out to get it displaying properly. I have the below formula: ="as at "&TODAY() and it is returning "as at 43916" I would like it to return the date in date format not as a number. Thanks in advance for any help.

Hi All, I need help with the following issue: I have a database (Sheet name is Data) in which data is updated monthly. Based on this data base I have put the following formula in an additional sheet (sheet 2). In cell O8, I have the following formula: =LOOKUP(2;1/(Data!K:K<>"");Data!K:K) This...

I have a text string containing either 7 or 8 (MDDYYYY or MMDDYYYY) digits which I want to convert to a date value. I can use the Text.PadStart to convert all of the text string to MMDDYYYY, but am still having a lot of trouble using the Date.FromText function to get this in date value. I am...

Hello, I'm ashamed to say having a harder a much time then I hoped to create an excel formula for a work report and ask the experts fo your help. Please! I have a straight forward excel table and reference a date/time/AM/PM from one cell and perform a text string function to break out the...

Hello forum friends, I am trying to come up with a formula but I feel like I’m spinning my wheels just trying to get it started. What I need is a formula that will return a line of TEXT with two dates embedded in it. I would like the returned text to look like this: Between September 23, 2018...

Hello! I have data formatted like this: <colgroup><col width="64" style="width:48pt"> </colgroup><tbody> 51767 72236 112380 100886 42466 100665 </tbody> The problem is that these are Dates of Birth and I need them to look like: 05/17/67 07/22/36 11/23/80...

I have a spreadsheet with a few hundred lines of data. From that data, I need to SUM a quantity value from each line that meets a few criteria. The part that is confusing me most is trying to pull the MONTH in 3-digit character form (i.e. FEB) from a Date field (i.e. 2/26/2018) and comparing...

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...

Hi All, I've tried countif using substitute, but I know I'm missing something. I can't figure out how to incorporate counting column B (numbers) if SOME of the text from column A matches column C, provide the total numbers of column B. Ultimately, I would need 8 different text to find. I'm...

Hi there. I am at an intermediate level with excel and a beginner with VBA. This is also my first time posting to a forum, ever. I have been having some trouble with completing a specific task for a project at work. I am attempting to link multiple cells I have in sheet 1 to multiple cells with...

Hi All, I have a spreadsheet which re-orders on a few different criteria, but need help modifying my sort on date (my third level sort) to allow for both dates stored as text as well as the dates stored as actual date formats. We use both formats to indicate different requirements: Text format...