Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Capturing a cell value as a function of a date
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Capturing a cell value as a function of a date
=(TODAY()-39113)*100/15+100
-- Gary's Student gsnu200705 "Ken" wrote: 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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Capturing a cell value as a function of a date
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. "Gary''s Student" wrote: =(TODAY()-39113)*100/15+100 -- Gary's Student gsnu200705 "Ken" wrote: 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? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Capturing a cell value as a function of a date
=(TODAY()-39113)*100/15+100
-- Gary's Student gsnu200705 "Ken" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
List of functions contained in the add-ins, esp. Analysis Toolpak | Excel Worksheet Functions | |||
How do I know which cell a function is called from? | Excel Worksheet Functions | |||
Mileage Claim Formula | New Users to Excel | |||
date format and the RIGHT function | Excel Worksheet Functions | |||
date format and the RIGHT function | Excel Worksheet Functions |