date calculation

  1. G

    bi-weekly occurrence within given range

    Hi, I am setting up a family budget planner, and want to list the fixed outgoings (Description / Amount / Frequency [Monthly / Weekly / Bi-Weekly] / First Date Taken. The variable outgoings, I want to list in a separate table (Date / Description / Amount). The problem I am having is as...
  2. E

    Days until the next date

    Hello All: I need some code. I have 40 cells that may/may not contain dates. Range is H19:H38 and I19:I38. Here is my need via example. If H19 has a date and I19 is empty, I need to know how many days (based on the current date) until the date in H20. If H19 and I19 have dates and If H20...
  3. S

    Payables Cash Requieents

    Cash requirement for an Accounts Payables environment. Link provided for sample data set with desired date results highlighted. https://1drv.ms/x/s!Auu67iC5u960_VhNg5EF3ywaGrCe To provide an accurate detailed daily cash required forecast for payables, invoices and credits must be calculated to...
  4. X

    Date calculations formula

    I have 2 dates i.e. 5-Dec-16 in cell A1 & 10-Nov-17 in cell B1. Is there a way to calculate the number of days broken out relative to each year? Thanks
  5. L

    Adding and subtracting time and date within a specified date range

    Hi, I need to create a dynamic table that helps with backplanning from a specified date and time. It's meant to be used for project management, so I essentially something like this: If someone enters data into the blue boxes the full table should populate with dates and times in the format...
  6. C

    Need Formula to Stop After Certain Date is Reached

    I am running a pref calc on a property with multiple investors and the pref % changes each year. However it is not compounding so no pref is earned on pref from the previous year. How do I stop each formula once 365 days have passed and then begin with the new pref for the next year?
  7. N

    Incrementing Cell Address Numbers by Formula

    I am trying to create a formula that will populate a non sequential set of cells in a column with data from another column that is sequential. I can't seem to figure out how to do it. For example: I have in one column that is a textual form of the date: Column B <tbody> August 31, 2016...
  8. B

    Conditional Formatting 'greater than/less than' for cell containing variable date based on a formula

    Please please please someone help! I have a spreadsheet as below. A2 - 'Date Approved' is manually entered, B2 - 'Review Date' and C2 - 'Trial Expiry' are automatically calculated based on the date entered in A2 - 'Date Approved'. I need to conditionally format as follows: B2 - Cell to turn...
  9. L

    Automatic date calculations

    Below is a list of bills, I'm trying to figure out a way to have the Due Date column automatically calculate each month after the date is passed i.e. today is October 30th, so every due date before that will automatically show the dues date in NOV. Like bill # 1 is due the first of this month...
  10. D

    Calendarize invoice data into standard calendar months

    Hello, I'm working with a large number of invoices that do not follow standard calendar dates (i.e. the first day of the month to the last day - 8/1/13-8/31/13). I'm trying to find a systematic way to convert these invoices into standard calendar dates so I can evaluate various locations...
  11. S

    VBA Array - Help with Date Calculation

    Hi All, I am a newbie to VBA programming and I am very much interested to correct my mistakes However, I am unable to solve a problem that involves calculation of Weekdays and storing them in an array Excel Version: 2007 Problem : Column A Column B Column C 16-May-13 19-May-13 In the...
  12. S

    Date Calculations

    Hello, Can someone help me with this. I have a spreadsheet to track vehicle buyouts, each vehicle has a row and the columns would look something like this; Vehicle Number, Start Date, End Date, Monthly Amount, Term 00698 - Ford, 1-Sep-10...
  13. G

    Changing Text Format with Formula or Conditional Formatting with multiple values

    Hello all! To give you an idea of what I am trying to do, let me break down what I have... I currently have a workbook with multiple spreadsheets used to track requests received, and follow them throughout their life... sort of a "help desk" type of tracker, where we assign a ticket number and...
  14. S

    Complex Date Calculation Help

    I am wanting to create a school calendar that calculates student hours based on one of six schedules, omitting weekends and given holidays. The schedules might be: M - F all day (5 hours per day) M - F a.m. (2.5 hours per day) M - F p.m. (2.5 hours per day) MWF (5 hours per day) MWF a.m. (2.5...
  15. K

    Date calculation and rounding within a fiscal year

    First of all: best wishes to all the geniussus (i.e. you, yes you know who you are). I was wondering if any of you has had this challenge before. I'm trying to do a date calculation in a fiscal year. I have a date (1-26-2010) and want to add a number of days (90) I then want to round down to...
  16. P

    datedif count down before or after today

    Hi, I have a list of service dates the can be either a future date or a past date? I want to reference the today function and look at the list of dates and tell me how many months have passed between the two dates.i would like it to show say 30 months to go till next service or -30 because it...
  17. N

    Set day and month on date column formula

    Hi, I have a date-time column [CreatedOn] e.g. 11/08/2010 11:31. I need a formula to extract the year e.g 2010 and then set the day to 01 and the month to 06 and the time to 00:00 and return this as a date-time value. The formula might need to be two parts extract the year from the CreatedOn...
  18. A

    MS Query - Dates and INT functions

    Hi I am using MS Query to return data into Excel. I know Access but am quite new to MS Query and keep finding vast differences between the two!! I've looked on the help but it doesn't seem to be of any! I have two date fields which are formatted as dd/mm/yyyy hh:mm - and I need to take one...
  19. J

    Date question: calculated date + specific day of the week

    Hi! Your help is greatly appreciated! Bid openings are always on Wednesday. Advertisement dates can be any weekday. A project must be advertised for a minimum of four weeks (holidays, weekends not excluded). I need to calculate a date, based on the (advertisement date) that is a *Wednesday*...
  20. G

    How to calcualate the number of days passed in a column after date set in another column

    Here is the scenario: I have Column A that holds the date and Column B that shows many days have passed since that day in Column A passed. For example - if the date in Column A is 7/1/2010, Column B shows 8 because a total of 8 days passed from the value in Column A up to today's date...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top