calculate dates

Hi guys, I have a huge table with many columns and rows. Then in another sheet I have certain values that I need to use to calculate dates, so I need to Example of values that I need to use for my calculation: Customer: SZ Final date: 10/07/2020 0:00 Transportation lead time: 96:00:00...

Hi, How to get deference between two dates in mac excel 2016 i tried but it is not working accurately Refer screenshot Ex: date - date2 =( 2 years 4 months 11 days) in one cell

Hey all! I'm no EXCEL expert but can usually figure out less complicated formulas, however this one has me stumped. I'm working on a project which requires me to calculate a minor child (patient's) date of majority (when he or she turns 18), then add 3 years to that to arrive at a date at which...

Hello again. Looking for help again. Here is the table where D is Date money taken by client AW-BH are the months of the year each cell contains the % paid by client. Normally when the client is paying before or at the end of his month he pays whatever shows H column. As example...

I need to calculate the amount of time used on public computers in a library between the ours of 2PM and 4PM or 14:00 and 16:00. I have login timestamps that overlap both beginning and ending time period in which I am interested. If someone is logged on between 1:38PM and 2:24PM (13:38 and...

Hi guys, I was wondering if someone could help me put a VBA together that will help me calculate start and end dates based on total number of days of certain training topics, this is an example of my spreadsheet, just as a side note, I will be providing the first start date, but then want all...

Hi, I have monthly budget numbers eg Date Budget 31-01-2013 100 28-02-2013 200 31-03-2013 300 ... If today's date is the 20-02-2013, I'd like to calculate what today's budget number is (based on a straight line calc. from the 2 known points either side of today's date). I can plot the data...

Hello, I need help. I am creating an excel sheet where I have a list of names and dates to correspond with each of those names. Now, I have another sheet where I want an autopopulated list of those names and dates that are within a range of days since the original date. For example, I own a...

I have a drop down box that chooses the week number of the year (This is based off of a series of data from another sheet).<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> I need some kind of formula that calculates the following Friday based on a week...

Hello, I need to calculate the hours and minutes we respond to something but only counting the hours and minutes that fall within 08:00 to 17:00 Monday through Friday. Example - if we received a call at 09:00 06/01/11 but did not arrive until 10:00 6/2/11 hour 'covered' hours are only from...

I am trying to find a formula that will give me the date four days from the date I put in a cell but I don't want it to count certain dates as those four days. Is there a way to do that? <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p>