| 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
=(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
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? |
| 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 | |||
Linear Mode
