Data Reporting/Extraction on specific dates

[Ritesh89]

Hello Everyone,

I am new to Excel and need some help for my project. I want to extract a particular cell value on weekly basis. The start and end date of project is known. The cell value named 'percentage of work completed' updates every day, but I want to know the status only on weekly basis.

Column A1: A10 contains the reporting dates
Column B1: B10 should display the percentage of work completed on that reporting day
Cell $C$1 contains the current percentage of work completed

So basically, I need a formula which will capture the value in cell C1 on the dates mentioned in A1:A10. I need this for weekly status reporting.

Please Help.

Regards
Ritesh

 

[The_Macrotect]

Hi Ritesh,

For something like this, you'd have to use VBA. What exactly would you like to be done on the specific dates in A1:A10? When would you like Excel to check the dates to see if it's time to run? (Every time the workbook is opened, every time a specific cell is changed, every time any cell is changed, at a certain time every day)


Running the code on those specific dates would looking something like this:

Sub run_report()
Dim x As Integer

For x = 1 To 10
If Cells(x, 1).Value = Date Then
' place code to be run on specified dates here




Else
End If
Next x
End Sub


All the best,
Matt

 

[supladaiii]

Hi. Are you looking to SUM B1:B10 if A1:A10 matched the date range you require??
If so, here's a couple of ways:
<code>=SUMIF(A1:A10,">=mm/dd/yy",B1:B10) - SUMIF(<code>A1:A10</code>,">=<code>mm/dd/yy</code>",<code>B1:B10</code>). <code>You can also use a cell reference for the beginning and ending dates instead of modifying the formula every time (see SUMIFS below)</code>
=SUMIFS(<code>B1:B10</code>,<code>A1:A10</code>,">="&E2,<code>A1:A10</code>,"<="&E3)


</code>