date and future

  1. C

    Date formula

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

    Output dates based on current date/quarter/week

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

    Amortization Schedule Formula Problems

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

    Anniversary date in a series of start and end dates

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

    analyse 3 columns, return date of next purchase for same client and product (Index Match)

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

    Calculating to a specific date

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

    Weeks + date calculations in vba

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

    Don't count cell B if data in Cell I is the same month - Dashboard

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

    Creating a table with months and years given a start date

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

    Max date

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

    Date function

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

    Link Text to different expiration dates

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

    Help with Dates and Day of week

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

    Trying to make an equation and an "IF" logic test only occur after a date, help

    " 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...
  15. B

    Calculate a date using days from a base date.

    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 #...
  16. R

    Formula for forward looking leap year date

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

    Conditional formatting based on past and future dates

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

    formula to auto input a date

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

    Project Mgmt: Converting Earliest and Latest Start, Finish Times and Slack into Actual Dates

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

    Project Mgmt: Converting Earliest and Latest Start, Finish Times and Slack into Actual Dates

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

Some videos you may like

This Week's Hot Topics

Top