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...
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.
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)
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...
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...
I have data formatted like this:
<colgroup><col width="64" style="width:48pt"> </colgroup><tbody>
The problem is that these are Dates of Birth and I need them to look like:
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...
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...
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: