future

Hello Friends, I have column which contains only dates and blanks - based on Date Column it has to provide the information as Current or Future date. Based on table below, If Column A is Lesser than or Equal to 30th Sep 2018 then Column B should show as "Current" If Column A is Greater...

I have a workbook where I enter a specific date such as today into an input cell, and I want the formula to output if the record date is one of the following "Previous", "Current" or "Future". If I input 6/19/18 into my input cell then --- If before the 1st of the month of June then "Previous"...

Hi All, I would like to after an active row has been filled that VBA will automatically locks that row from being changed in the future. Can someone help me with this coding? Thanks, Pinaceous

I'm using this formula to work out if a date is in the past or future; I need to take it one step further though - can I include if the date in the future is more than 6 days ahead? If it can be done I need it to show "Too Far". Thank you!

Hello everybody, I am writing a vba function that assigns a value of 10 * a probability to each calendar date in the future, only if that date is within -5<date<5 the next closest date from the EVENTS list (on the left below the excel example). So if I am on the 17/04/2018 and the closest...

What would be the best way of going about getting the nearest future date from 3 dates using todays date? A---------- b----------c-----------answer 3/29/2016 3/29/2017 3/30/2018 3/30/2018 2/15/2019 2/15/2020 2/15/2021 2/15/2019 6/25/2016 5/25/2017 5/25/2018 5/25/2018

I have a table with two year columns: Current_Year and Future_Year. I need to SUM the amounts where Future_Year equals Current_Year, but exclude records where Future Year equals Current_Year. Using the Data below, if Year 2000 is selected on the Current_Year slicer, I would need it to SUM...

James, Roy, Rich, Charles, Julie, Alice, Hector, Vinton, Kiera, and Corey are travelling. They are staying at a flat at 33 USD per day. They all have money but not equal and they are going to pay in sequence as mentioned in column. If someone don't have enough money the next person is going...

Hi All, I’m new to MS Access (have some VBA experience but no SQL) and have a question related to Forms. I have two combo box fields (Exchange & Future) in a form, both drawing data from the same Table (Product Details). Users (in the form) first select values in Exchange and then in Future...

Hi, This is my first time posting, hopefully someone can help. I have a list of times and a matching list of payments - Times in cells C4:C14 and payments in cells D4:D14. I have formulas to show the time of the next payment in cell F4 {=MIN(IF(C4:C14>(NOW()-TODAY()),C4:C14))} and one to...

Hello all, I'm trying to use conditional formatting to highlight the row of data with a date that is closest to today but not in the future. I am currently using =$A2=TODAY() in conditional formatting, but this will not highlight the date if today's date is not on the list. I would like to...

I have two worksheets in my workbook. Sheet 1 is called Front and sheet 2 is called Details. Cells A5-A57 contain events and Cells B5-57 contains the next date of the event in Column A. Column B gets the data from the Details Sheet. The formula I used to get the date of the next (future)...

Hi, In Column N, I have a drop down with 7 options: Later Next 1 Next 2 Next 33 Future 3 Future 4 Future 43 In column M, I want to categorise them in 3 options = Later, Next and Future but I’m getting value error. This is what I tried...

I need to display the MONTH and YEAR of a future date. I'm using NPER in a calculation that returns what appears to be a LONG value (in months), and I want to add that to a specific date. I can easily figure out how to turn 5.832412335 Years into a nice rounded/truncated number = 70 months...

Hello, I'm wondering, what are the thinking around this question, what is the future of VBA ? From my understanding, Microsoft have deprecated VB and VBA doesn't seems to be taken care of since several years now (5 years, 7 years ?). Also, today is VBA still the way to go when it's about...

Hello fellow excel friends, I want to see if my thought process seems logical, or if yall have better ways to do this. I have a large data set with financed purchases in my industry. I created a formula to show how many days in between purchases, avg day between purchases, days till last...

In the company we use tools, which have at the end of the cutting plates-inserts. These plates-inserts are changed at different intervals. I have a table with plates-inserts in next cell interval after which they must change. Worker view piece id, and find value in the table - top of the...

I don't have a hotline to Microsoft or a pre-alpha copy of Excel 2020, but I was thinking about where Excel might be headed over the next few years and came up with 8 bold predictions. What do you think? Do you have any other predictions/ideas about where it could/should go...

I have some historical data from year 2009 till now, for each month of the year and for 7 items. What I want is to make a report table (same or different Sheet) to automatically show a simple estimate of data for the future months (based on actual ones), every time I enter data for a month. I'm...