New Date When Another Cell Value Increases

Aug 1, 2009

In sheet 1 of my workbook I have a spreadsheet with lots of different data, most of this data is pulled from our own internal process books.
The problem I need help with is,
Cell "A5" contains a storage tank level.
Cell "A6" contains the date the storage tank was last filled, (this info is required for auditing purposes).
If possible I would like to automate the date entry.
So when the level increases by say 2.0 I would like the new date in cell "A6". I don't want that date to change if the level stops the same or decreases. So the date will not change again until the storage tank has been emptied and refilled.

View 9 Replies


ADVERTISEMENT

Popup If Cell Value Increases?

Aug 7, 2013

I have a cell (c9) that increases on an integer basis using a rounddown function that in turn is looking at a calculation in a different cell. Is it possible to create a pop as the integer value in c9 increases by 1?

View 3 Replies View Related

Count Consecutive Increases From Last Value

Sep 22, 2011

I'm trying to come up with an array formula to count the consecutive declines or increases from the last value in a column, going from bottom to top. The real world application is a list of daily stock prices down a column, and counting from the most recent day, how many consecutive days the price declined or increased.

I got some hints in the following post but can't get it evaluate the resulting logical array in reverse order (which is needed since column addresses are evaluated top to bottom, not bottom to top).

Count consecutive increase in values

Example for consecutive increases leading to last value
49
50
51
52
53
49
55
56

I need a formula to return 2, the number of increases from 49 to 56.

View 5 Replies View Related

Looping Macro, Number Increases - 2007

Aug 26, 2009

The following is the macro I have created, but I can't get it to loop. I need to insert a row below Labour-Overtime about 100 times in the document, not just once. Until the bottom. Also, active cell 1013 needs to be the same as what is above it. The series repeats and goes up by 1 every time. Not sure how to get that to work.

View 5 Replies View Related

Dynamic Chart That Grows As Data Increases

May 6, 2012

I want to make a dynamic chart that grows as the data increases

The data is from C23:O23 (12 Columns)
The Months are from C22:O22 (12 Months)

I am only on month 4 (April) but this will eventually but 12 months

Looking at various sites you have to use a dynamic named range and in the Refers box drop in an OFFSET formula.

My problem is I cannot figure out an OFFSET formula for columns instead of rows.

View 6 Replies View Related

Interest Rate Calculation With Payment Increases

Mar 4, 2014

I have a capital lease amortization schedule with annual increases to monthly rent that I am trying to solve for an interest rate such that the balance nets to zero at the end of the term. I am calculating on a monthly basis; in other words, principal minus monthly payment plus monthly interest expense equals ending monthly balance is calculated in each row each month. The present value is known, payment term is known, future value is zero, and the payment amounts increase annually. These assumptions may change for new leases so ideally the solution would be dynamic, adjusting for shorter/longer terms, etc. Here is an example of my assumptions:

Payment start date: 8/1/13
Term end date: 10/31/2025
Rent length in months: 144
1st months rent: $500,000 - payments are due at the beginning of the month and are paid monthly
Annual rent escalation: 3% - i.e. 1st 12 months is $500k/month, 2nd 12 months at $515K, etc.
Beginning NPV: $75M
Ending value: $0
Imputed annual interest rate: UNKNOWN

I'm not sure if this is relevant, but the monthly payment is allocated between principal and interest. Monthly interest expense is calculated as the current balance * (imputed interest rate / 12).

Currently, I've plugged the interest rate such that my ending balance is 0, however I was hoping to calculate it on the fly as opposed to manually plugging it.

how to calculate annual interest rate with these inputs? Is there a way to make the rate function work with payment increases?

View 7 Replies View Related

Textbox Text Increases In Size With Click

Jan 27, 2008

I am using Excel 2003 on Windows XP, and I have created a form using several TextBox controls on Worksheets (not userforms). When I click on a textbox that has some text in it, the size of the text grows. Clicking away from it, and then clicking on it again causes the text to grow further. Repeating these actions ultimately causes the text to be so large that the contents are illegible. There is no VBA code manipulating the font in the controls, they are only set initially through the settings in their properties (all textboxes use the same font). The problem occurs on multi-line as well as single-line textboxes. In debug mode, I can see that the font.size has not changed from the initial setting of 9, so there is no manipulation of the settings. It looks like the control is being zoomed, as the size of the vertical scrollbar grows along with the text. Closing the file and reopening it doesn't resolve the problem. The textbox retains the size that it has grown to. This problem seems to happen on some environments and not others, and I have not been able to determine the cause or factors that contribute to this phenomenon.

View 5 Replies View Related

CommandButton Font Size Increases On Each Click

Jun 28, 2008

I am experiencing exactly the same problem as described in Textbox Text Increases In Size With Click here, so browse to the following location to view the sample file:

[url]

username "turbocam"
password "danielsresort"

View 7 Replies View Related

Sliding Scale - Figure Increases And Moves Through Thresholds Pay Changes?

Jul 18, 2013

I have a single figure and as the figure increases and moves through thresholds the pay changes. e.g.

Number of sales payable = 15.66
Level 1: 1-10 pays 100 for each that falls in this threshold
Level 2:11-15 pays 150 for each that falls in this threshold
Level 3: 16-20 pays 200 for each that falls in this threshold
Level 4: 21+ pays 250 for all above this

I want to work the amount payable with a formula.

It should be $1849

Is there a formula that can calcualte this without me manually figuring out how many in each threshold.

View 3 Replies View Related

Resize Active Window - Increases Height Of Workbook

Jun 7, 2014

I was just wondering if it possible to create a macro that permanently increases the height of a workbook by a set increment

I have several workbooks that i have the code below assigned to

[Code] ......

So when they open they resize to that set size and position. and what ive been doing if i need to resize (which is often) is just adjust the values in the above code.

Not that the way ive been doing it is difficult but i was thinking how great it would be if i could have a macro i could run that permanently adds 9 to the .Height and subtracts 9 from the .Top

View 4 Replies View Related

Insert Picture From File Increases File Size More Than The Picture You Inserting

Mar 17, 2009

I am putting together a price list in excel and using images and hyperlinks to jazz it up a bit - what I am finding is that if I insert a 25KB GIF image, the excel file grows in size by over 100KB

why is this disproportionate growth happening and is there a way around it - I dont want my Price List growing too large but need the images....?

View 9 Replies View Related

Macro To Delete Cell Contents If Date In One Cell Bigger Than Date In Another Cell

May 9, 2012

I have the following columns that return cover period dates.

Start of Cover PeriodEnd of Cover Period01-Nov-0631-Jan-0701-Jul-0831-May-0901-Dec-0930-Jun-1001-Jan-1131-Dec-10

I however need a macro that will delete the cell contents if the "Start of Cover Period" (column AK) date is > than the "End of cover period" (column AL) date.

Thus it must compare ak2 with al2 and if ak2>al2 then clear both cells. if AK2

View 2 Replies View Related

Add A Date Time Stamp In A Cell After Data Is Entered In A Different Cell And Date

Apr 18, 2014

I am working on an Inventory Spreadsheet. I have need it to date time stamp that willpopulate a different cell /field when text are entered in a different cell/field and will not change all the previous dates entered on the spreadsheetevery time I re-open the spreadsheet. I formula I am using is =IF(E3<>"",IF(D15="",NOW(),D15),"")and it changes each time I open thesheet to do the inventory so I do not know the date of the last inventory. Iwant to capture the actual date that the inventory was completed in thesecond/different cell?

View 9 Replies View Related

Roll On Date 11 Months In One Cell When Another Cell (date) Is Amended

Jun 5, 2009

I have had a look via search for similar but I'm not good enough to recognise whether other threads bear any relation to my query.

I have a small spreadsheet with basic conditional formatting (my level!) where we record agency staff for eleven months service to enable us to ask them to take a four week break.

I want to add a formula or similar to automatically roll the date forward eleven months when we amend the re-commencement date on their return.

E.g. we type in A1 01/01/09, B1 updates to 30/11/09

Is this possible?

View 10 Replies View Related

Date/time Macro: Inserts The Current Date And Time In The Selected Cell Regardless Of Where That Cell Is

Oct 20, 2009

What is the code i need to use to assign a macro to a command button which inserts the current date and time in the selected cell regardless of where that cell is?

View 5 Replies View Related

IF Date Formula: IF Formula, That States If A Date Is More Than A Month After The Date In The Cell Then It Is Timely

Jun 2, 2006

I need an IF formula, that states if a date is more than a month after the date in the cell then it is timely and if it isn't then it is not timely. For example the date in A1 is 12/11/05, if the cell is A2 is 13/12/05 (or any date after that) then A3 should read Not Timely, if A2 is 12/12/05 (or any date before that, including a date before the date in A1) then A3 should read Timely. Is there any way to do this?? At the moment I am having to go through manually and put in either Timely or Not Timely.

View 2 Replies View Related

Calculate The Number Of Days From A Date Entered Into Cell A1 To Today's Date

May 19, 2009

I need a formula that will calculate the number of days from a date entered into cell A1 to today's date. Whether it's before or after todays date. Example:

5/10/2009 to today is -9

5/22/2009 to today is 3

View 2 Replies View Related

Excel 2010 :: Converting Hijri Date To Gregorian Date From Another Cell

Apr 19, 2014

I have a spreadsheet where we will be inserting the Arabic Hijri date taken from a Customs document (bayan). On my spreadsheet I'd like to have a column immediately next to the Hijri date that would convert the Hijri date to the Gregorian date so both dates will be visible for our Arabic and Western personnel who will be using the spreadsheet.

I am using Microsoft Excel 2010.

View 3 Replies View Related

VBA - Validate Date Entered In Input Box Is Month Ahead Of Date In Cell

Aug 14, 2012

I have a input box that prompts a user to enter a date of a new month - it has to be the 1st of a new month. I have validation that it is a date that has been entered but then i want to validate the date entered is a month ahead of a date in a cell range on a sheet.

It is a monthly reset so it has to roll on from the previous month.

Here is what i have currently but it isn't working.

Code:

' Get user to input the first day of the new month to populate all dates with
dNewMonth = InputBox(Prompt:="Enter first Day of the new Month. Must be the 1st of the Month e.g. 01/10/2012", _
Title:="Enter Date")
' Validates the entered date is a valid date
If (IsDate(dNewMonth) = False) Then

[Code]...

View 1 Replies View Related

Pull Date & Times Into Seperate Cells From Date & Time Cell

Apr 2, 2008

DONNAS [Single cell, 1st row] 09/08/2003 15:34 [Single cell ( date and time combined) 2nd row]. Do you know of any way that I can move the name, date and time from the above cells to three separate columns on the same row?

View 4 Replies View Related

Stamp Cell With Today Date Without The Date Changing Tomorrow?

Feb 7, 2013

If a1,a21,a41 have a value greater than 0, I wish to stamp cell b1,b21,b41 and so on with todays date, but without the stamped value changing/advancing tomorrow. At the moment cells b1,b21,b41 are copied down as follows. =if(a1>0,TODAY(),"") This works fine, but the date stamp of course changes tomorrow. I can not apply code to the whole b column as cells b2:b20, b22:40 etc have other non-date format data to which the code does not need to apply - the todays date value cell occurs every 20 cells.

View 6 Replies View Related

Calculate Date Difference & Use Current Date If Cell Empty

Sep 22, 2007

i am trying to create a forumla in a column (D in my expamle below) to count the number of days between two dates. Knowing that col D will change everytime the @now date changes - but thats ok..

COL A COL B COL D
ROW 1 Open Date Closed Date Count of days open
ROW 2 4/1/07 BLANK CELL Formula result here
ROW 3 4/1/07 9/5/07 Formula result here

if col b has a date then subrtract col a from b and display the # result, if col b is blank then subtract col a from location I store the @ now date - say Col ZZ Row 99? so no matter there is a count of number of days in every row in column D

View 3 Replies View Related

If Date Cell Less Than Todays Date Calculate Difference In Days

May 13, 2008

I have column B with a heading "Days Remaining" and column L with a heading "Deadline". starting with row 5, I need to be able to enter a date in L5 and see the days I have left, from that day untill today, on B5. I need to then be able to enter a date into L6 and see a result in B6 and on and on. Then I need to be able to insert or delete a column and have the formulas still work in the columns with the heading "Days Remaining" and "Deadline"

View 7 Replies View Related

Check Cell Has Date & Insert Current Static Date

Jun 25, 2008

I have a user form that when a command button is clicked it enters the data from the from into coloums a,b,c,etc. I have code to do this but I want to add code to add a static date in coloum B based on if coloum A had data entered from the form. I need the date not to change to current date when the file is reopened. I am trying to elimate a date text box in the form. I have a link to the file http://www.box.net/shared/zdtsjv0qos

View 7 Replies View Related

Prevent Automatic Date Format When Referencing Date Cell

Aug 1, 2008

I have been struggling with my Excel 07 Date format. Nearly every time I perform a calculation, enter in a value etc in a spreadsheet my answer is returned as a date. So for example if I enter in a cell: = 5 - 4. I get the answer "1-Jan-1900" instead of 1. I have to manually set the formats to general or number if I want the correct format. The setting seems to be the default one and occurs for all workbooks I open. What can I do to change this.

View 5 Replies View Related

Comparing Previously Entered Date With New Date In Same Cell?

Apr 15, 2014

I'm working on the final stage of a project. I'm attempting to write code that will set off a chain of events if two dates are 91+ days apart from each other . I've attached a sample worksheet that shows the bare bones basics of what I'm attempting to do.

What will be the most efficient and effective way of accomplishing my goal: userform, functions, formatting, etc.? T

View 14 Replies View Related

Sending Email When Date Reached In Cell Date

May 27, 2014

I have a "to do" spreadsheet as follows.....

Column A - nothing
Column B - Subject (thing to be done)
Column C - not relevant for this
Column D - not relevant for this
Column E - not relevant for this
Column F - importance
Column G - Deadline date

I would simply like excel to send an email to my boss (example@example.com) and if possible myself 5 days before the deadline date: email subject - '5 days left' . Email content - what ever is in the subject column for the relevant duty.

View 3 Replies View Related

Date Formula: Date Another Cell Rounds Up To Jan 1st Of The Next Year

Oct 22, 2007

what formula could I use when I type in a date another cell rounds up to Jan 1st of the next year? ie 2/1/07 & in another cell it returns 1/1/08.

View 3 Replies View Related

Search & Replace Date In Date And Time Cell

Aug 16, 2008

I have several hundred rows of date/times which I need to modify just the date (for example 08/23/2007 11:00 to 08/15/2008 11:00). Each row may have a different time so it is just the date I'm targeting for change.

If I manually use the replace dialog, replacing 08/23/2007 with 08/15/2008 works just fine. However, if in code I attempt to use the Cells.Replace function, it does not locate any data to change.

I have found that if I search for the string 8/23/2007, the dates are located and changed. Only when I attempt to find the fully formatted date 08/23/2007 does the function fail.

View 6 Replies View Related

Delete Rows If Cell Contains Date Outside Date Range

May 29, 2008

I've found similar queries on the site, but none seem to handle multiple dates, and my attempts so far have been futile!

Requirement:
I press a button on Sheet1 and am prompted to enter a start date and an end date.

Depending on the dates I enter, all rows on Sheet2 which fall outside the Start/End date range will be deleted.

All dates to be checked against on Sheet2 are in a single column, and all rows are populated, there are no blanks. Dates are in the format dd/mm/yy

View 5 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved