today

Hi All, I am new to Excel so apologies if my question will miss pieces of information or is not clear. We work within the Construction Industry and make monthly projections of our turnover based on prospect. BACKGROUND We assume based on the size of the fee - which is related to the size of...

Hi - I have a spreadsheet with data in columns A:E. In column B is a date. I would like to remove all rows with a date more than 7days older the today(). Ideally i'd like to have a popup that asks remove dates prior to? thanks!

Hi, I was looking for a formula to calculate Months and Days Until Next Birthday. I found this thread https://www.mrexcel.com/forum/excel-questions/355165-months-days-until-next-birthday.html It works well, unless the birthday month and day are the same as today. In that case (e.g. birthday...

When transforming data I have a situation. A field called "Booking Qtr" comes in from a source with 4 choices right now: FY19-Q3 FY19-Q4 FY20-Q1 FY20-Q2 When we are in Q4, FY19-Q3 "drops off" an then the data will also have records with FY20-Q3. I want only 2 groups of data: "Current", which...

=IF(AL2="",AND(OR(AD2="Coffee",AD2="Tea",AD2="Soap",AD2="Milk"),YEAR(AE2)>TODAY())) Hi, Can someone help me correct the above formula? AL: Column has words and blanks from inventory (Blanks remaining inventory, filled are sold) AD= Is the product we have AE= Date So if the AL column is...

I have a range of cells d24:g24 that either have a date in them or are blank. I need to put a formula in h24 where the word Alert will appear if any of the dates are less than 180 days from today. Can anyone help?

I need to add two horizontal lines at 60% and 90% to a bar graph. I also need to change the text color for one of the items in the Y axis. They are survey responses and the text of the word is in the Y axis. I need to differentiate one of them that is reverse coded by font color or italics. I...

Hello there. I found a measure formula to display only dates before today. Is there a way to count only dates occurring in the next 30 days? The first formula was added a measure to a visualization so i suspect I would need to add another measure to the same visualization to show the next 30...

I need to determine the age of a transaction from a historical standpoint. Normally I would use =TODAY()-A1 However, I have to produce historic data and when entering this formula, I'm getting the data as if it were today. Example: I have a payment date of 11/23/2018 and need to calculate...

Same like TODAY() is TOMONTH() available ?

I've got a subroutine 'Print_Report' that calls another subroutine 'Check_Fields' and basically, if certain cells are empty then 'Check_Fields' exits the subroutine, but 'Print_Report' continues to run. How can I make one subroutine exit based on something in another subroutine? I tried using...

Hello, Is there a way I can use TODAY or NOW in a formula but make it static so that when the calendar gets updated the formula will return the same results? Thank you

Need help with a formula to calculate the number of weeks that have passed based on TODAY. I specifically need complete weeks. A1 = 4/29/2018 A2 = ??? (Number of weeks) (Today - A1?) Note: using MS Excel 2013

Hi, I am looking to use CF to show how many working days have passed from TODAY RED - 3 or more ORANGE - 2 YELLOW - 1 GREEN - TODAY Any help appreciated Thanks

Hi Guys, Trying to figure this out with no luck. I am using the following formula to highlight date ranges that overlap using conditional formatting. =SUMPRODUCT(($D5<=$E$5:$E$101)*($E5>=$D$5:$D$101))>1 What I am trying to do is make it so it only checks and highlights the dates that occur...

I have three columns: I am trying to say: If column B2 has a date then it should be subtracted by A2 but if B2 does not have a date then it should be subtract by today I know the formulas separately but i cant seem to put them together =TODAY()-A2)) = If(Isblank(B2), " ", A2-B2)

Help! I have a running budget spreadsheet that goes back for 2 years. Yesterday I used it and saved it. Today I went to add some info and it won't let me save it. How do I get it to save again???

Hi, I need a code that would take the name of a worksheet and rename the only table that resides on that worksheet to the same name. For example, if I change the name of a worksheet to "Today" the table on that worksheet would also now be named "Today".

I'm trying the run the below VBA and I'm getting the below error when doing so on the below line: ActiveWorkbook.Worksheets("Assigned Today - SD").AutoFilter.Sort.SortFields. _ Clear Run-time error '91': Object variable or With block variable not set My worksheet name that I'm running...

Hi there, Hoping to get some help with something I've been working on. Short version is information is pasted into a specific cell (where my offset is current pulling from) and I need it to return today's date, or yesterday's date if it has the "Mon" "Tue" "Wed" etc. I managed to figure it...