date calculation

I am making a task tracking grant chart using 2 input value Start(Date and time) and Duration(Hourly), to calculate their Finish by simply just Start+Duration/24 as you can see in this sheet. ABCD1TaskDurationStartFinish2Task11201-Oct 06:0001-Oct 18:003Task21301-Oct 06:0002-Oct...

Hi Clever Excel World, I have a sales sheet which in one column I have dates (the sales were made). When the sale has been processed and ordered we take this off the sheet but sometimes sales remain on there for a length of time. in another column I need to calculate the days that its been...

Hello, I have a large spreadsheet that I use to find patients that have had a procedure outside of their admission and discharge dates. The spreadsheet has worked perfectly until 1/1/2020. The conditional formatting formula I am using is: Cell Value ---> not between ---> J7 --->...

I am trying to work out a system of "Actual" versus "Budget" based on today's date. I have a column per month of expenses and at the bottom, it is totalled. Below that is a budget for that month for the entire column. As each day of the month progresses, I want the next cell down to show the %...

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

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

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

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

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

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?

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

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

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

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

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

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

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

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

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

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