date and future

Hi I need some help writing a formula. I have a table showing dates of birth for employees. I want to be able to show a "yes" in the table if the employee reaches the minimum age in months under each of the years. So for example, the first employee with a dob of 1/2/1960 should only have Yes...

Hi, I checked the other posts to the forum, but the tools were not specific enough. I'm attempting to display a due date based on the current date that coincides with the next quarter or week. Specifically, I want to know: - How I can find the Wednesday before the next month end - How I can...

Hello, We just signed on an equipment note for 5 years with 8 payments each year followed by a 4 month sabbatical. I made a change to the amortization schedule excel template we always use which only allowed for 12 consecutive months of payments. I think I have all but the date functions...

Hi folks, I am not sure how to Excel this problem. I have a series of start and end dates throughout the year, and over other years. For example: Start End Start End 2018-01-01 2018-04-01 2018-08-01 2018-12-01 I am trying to...

Hello Everyone, I have 3 columns of information. Column A with Client-ID, Column B with Product_ID and Column C with Date of Purchase. In Column D, I want to, after analysing the 3 columns, have it return the first date of the next purchase, IF the same client has purchased the same product...

Is there a way to calculate to a the closest specific date following a year? I am looking to enter a date, and have Excel calculate the date after a year, and then calculate the either FIRST 2/1 or 8/1 after the 1 year date. IE: A1 would have 3/31/16 ... the 1 year would be 3/31/17 ... the...

Hi, I am creating excel database (input via Userform) where i am facing two issues. could someone help me on below: 1. I am entering data through form and it is saving in sheet2 . The data contains numbers, date, text etc. But the numbers are saving in text format which is difficult for excel...

I'm building an interactive dashboard with slicers and pivot tables. My challenge is that I have two columns with dates. I need to calculate how many dates in the second column have a future date in the next month based on the referral date. Example below. What I'm trying to achieve is to show...

Hi, this is the first of a series of challenges I have with excel. I would like to have the user of my spreadsheet enter a date. I would then use that date to populate a number of cells based on the length of the contract (also added by the user). The first cell should show the month from the...

Hi I have source data into sheet1 like: <tbody> ColumnA ColumnB Audi 01/01/2015 Audi 30/03/2015 Bmw 06/06/2015 Audi 15/07/2015 Bmw 02/02/2015 </tbody> Into sheet2 I have unique list of values from columnA: <tbody> ColumnA ColumnB Audi 15/07/2015 Bmw 06/06/2015 </tbody> How to...

My date (J4) is 1/15/2014 If billing frequency (H4) is 1, I want formula to add 1 year, every year to 1/15/2014 If billing frequency (H4) is 2, I want formula to add 6 months, every 6 months to 1/15/2014 If billing frequency (H4) is 4, I want formula to add 3 months, every 3 months to 1/15/2014...

Hi, I’m work in the insurance business and want to be able to keep track of the forms I’ve sent to other companies. Due to different procedures of the companies processing times, the time I have to keep track of the forms differ. What I want is the possibility to have different company names...

I have a sheet where I would like for A1=the next workday (M-F) formatted as mm/dd/yy so if today is 1/3/2014 (a Friday) I would want A1=01/06/14 if today was 1/6/14 (A monday) I would want A1= 01/07/14. . Also it would be nice to have it not be something that is not like =today()+1 as I copy...

" http://tinypic.com/view.php?pic=35d5nas&s=5 "*Image of print screen of my situation Hi i am trying to create a dynamic personal accounts table in which to account for all of my inflows and out flows on my from my bank account, at the bottom i have created a simple balance checker which checks...

I am using EXCEL 2010. Problem: I am seeking to develop a formula that allows me to enter a starting or base date (example: January 1, 1970), a distinct # of days (an integer), and gives me as a result the month/day/year that the resulting date falls on. example: starting date : 1/1/1970 #...

I have several dates that require me to be forward looking and I need to ensure it accounts for leap year. The example is A B C Year: 12/19/2012 Years after: 20 Existing Formula: =A(B*365) , Result is 12/14/2032 I am...

Hi all, I'm struggling to know the right order to put the conditions in, if anyone could help please. I would like empty cells to stay blank/white Any cells with dates in the past or in the next two weeks (i.e past due or due soon) to turn RED Any dates not due in the next two weeks can stay...

Hi, I am a nurse at a prison and I have close to 1200 patients that I have to keep up with different medical information. None of our records are electronic so needless to say I am trying to create a "manual" E-MAR..that being said, I am administering TB shots and then entering the date of the...

Hi Ladies and Gents, I plan to use the critical path method (CPM) technique to manage a project I will begin working on soon. I therefore set up an Excel sheet with the following columns: Column A: Activity Code (different activities represented by different letters) B: Description of Activity...

Hi Ladies and Gents, I plan to use the critical path method (CPM) technique to manage a project I will begin working on soon. I therefore set up an Excel sheet with the following columns: Column A: Activity Code (different activities represented by different letters) B: Description of Activity...