text & date

  1. W

    Adding number of days to a TEXT date formula

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

    Format a date in a text string

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

    Formula to state the previous 12 months in text, based on changing contend in a cell

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

    Convert Text String to Date

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

    Use the Isblank & Iferror Excel function With Date/Time Cell reference

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

    Need help with TEXT formula returning valid dates

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

    Date of Birth to proper date format

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

    SUMIF / SUMIFS / IF(AND()) -- Help

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

    using IF statements to modify dates when referencing text

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

    Formula to Search multiple criteria of month/year within a cell and return total numbers from a different cell

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

    Connecting a text box on sheet one to multiple different descriptions on another sheet

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

    Help comparing ordering dates stored as text AND dates stored as custom dates

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

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back