Hi All, I calculated the number of days between two dates with =DATEDIF(A1,B1,"d")&" days ". Column 1 Column 2 ...

Loan template for repayment over 101 months showing capital amount and interest

worksheet 1 contains rows of data including a column of dates - I want to link the row with the latest date into a row in worksheet 2

I am working on a planning project that involves projecting populations. I am given populations for each decade (2010,2020,2030,2040) and after determining...

I am trying to include a Date cell on my spreadsheet that is automatically populated by the previous Date cell + 30 days. Is there any sort of formula in...

I have searched many posts but can’t seem to find anything similar, so I am having to ask for assistance please. I’m sure it will be a piece of cake for...

Howdy, I am working a homework problem involving non-linear programming for an operations research class. The problem is in three parts. The objective is to...

I am trying to test if an individual's birthdate falls within any of the given age division date ranges. I would like for it to output the age division...

I need to compute how much each sales person sells and their gross profit by month. Unfortunatly the manager wants the information by ship date, not by...

Anyone know how to copy an entire excel sheet from one folder into another separate folder in order to combine files, (correctly formatted and exactly the...

I have some outliers in a set of data, and would like another method, besides the TRIMMEAN to smooth the outliers. Trimmean "eliminates" the outliers... how...

I am trying to find a way to have excel recognize a bi-weekly pay period for a timesheet I am working on, but I have run into a problem. I can easily have...

Is it possible to use VLOOKUP or HLOOKUP on noncontiguous ranges? For instance range A1:D2,H1:K2? I've tried it using the cell references and by naming the...

Hi all! I've got the following table: A B C D E 1 t1 t1 t1 t2 t2 2 st1 st2 st3 st1 st2 3 v1 v2 v3 v4 ...

Sometimes a cell's formula displays on my worksheet instead of the calculation. Why does this happen, and how can I fix it? I've tried re-formatting the...

Real amateurs question - I have a list of times formatted as hh:mm which i need to sum. If sum of the values is less than 1 day the function is...

I need to list the possible permutations for 5 numbers using all 5 in each permutation. 1 2 3 4 5 2 1 3 4 5 1 2 4 3 5 etc.

How can I clear data from a worksheet with out erasing the formulas? I want to reuse last years sheet for this year. So how can I clear the data with out...

Save over onsite registration Atlantic City, New Jersey will once again host the Microsoft Excel / Access User Conference (Trump Taj Mahal) - On...

I am trying to update data in a spreadsheet that has a drop down menu list. I need to update the data in the menu list. How do i go about doing that? can it...