Capturing a cell value as a function of a date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i want to capture the calulated vlaue of a cell based upon the date. i.e. on
1/31/07 b2=100. on 2/15 it continues to update the calulation and now b2=200.
is there a function/formula i can use to capture what b2's calculated value
was on 1/31?
 
Gary's Student,

This appears to calculate the value on 1/31 based upon the exmaple I
provided. I am interested to see if i can automatically capture the value of
a cell on 1/31 that will continue to update regularly based upon data being
entered in a number of sheets. I am trying to avoid having to manually on
each month end date manually type the value of a cell.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Update cell value based on name and specific date 1
countifs Function not giving desired result with date criteria 2
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
is Retrieving a Cell address from a cell containing a SUMPRODUCTformula a problem ? 5
Data Validation with Blank Date 2
Allocate Value Across Monthly Periods 1
Cummulative sum against Condition 4
Using a date formula! 2

Back
Top