End Of Month Data Only
 

Hi,

I would like this spreadsheet, which last until 2005, to calculate only
end of month data. How can I do it?

16/05/1972 6179 6179 6178 6179 227
17/05/1972 6182 6182 6182 6182 210
18/05/1972 6184 6188 6184 6188 128
19/05/1972 6184 6184 6184 6184 135
22/05/1972 6185 6189 6185 6189 150
23/05/1972 6189 6189 6189 6189 266
24/05/1972 6189 6189 6189 6189 436
25/05/1972 6185 6185 6185 6185 276
26/05/1972 6187 6187 6186 6187 129
30/05/1972 6190 6190 6189 6190 289

Thank you.

air


--
air
------------------------------------------------------------------------
air's Profile: http://www.excelforum.com/member.php...o&userid=17272
View this thread: http://www.excelforum.com/showthread...hreadid=382637

End Of Month Data Only
 

I think I need more information.

I frequently keep daily information on one sheet, keep a running
month-to-date on a second sheet, and a running year-to-date on a third
sheet in the same workbook. These could be on the same spreadsheet,
just additional columns for the running totals.

Then use the EOMONTH function to find the information you need.
Col A Col B Col C Col D
Date Daily Val MTD Val YTD Val
05/25/05 6,179 6,179 6,179
05/26/05 6,182 12,361 18,540
05/27/05 6,184 18,545 37,085
05/28/05 6,184 24,729 61,814
05/29/05 24,729 86,543
05/30/05 24,729 111,272
05/31/05 6,185 30,914 142,186
06/01/05 6,189 6,189 148,375
06/02/05 6,189 12,378 160,753
06/03/05 6,185 18,563 179,316
06/04/05 6,187 24,750 204,066
06/05/05 24,750 228,816
06/06/05 24,750 253,566
06/07/05 24,750 278,316
06/08/05 6,190 30,940 309,256
06/09/05 30,940 340,196

VLOOKUP(EOMONTH(A3,0),A3:D18,3,FALSE)
yields 30,914


--
DCSwearingen


------------------------------------------------------------------------
DCSwearingen's Profile: http://www.excelforum.com/member.php...o&userid=21506
View this thread: http://www.excelforum.com/showthread...hreadid=382637

End Of Month Data Only
 

Your data is, at best, ambiguous.

What would a calculation of end of month data look like (presumably it
would be for 31/05/1972?)?

What are the inputs? what are the outputs? What algorithm is used to
calculate?

Where would the outputs be calculated - in-line? On another range/sheet?

In article ,
air wrote:

Hi,

I would like this spreadsheet, which last until 2005, to calculate only
end of month data. How can I do it?

16/05/1972 6179 6179 6178 6179 227
17/05/1972 6182 6182 6182 6182 210
18/05/1972 6184 6188 6184 6188 128
19/05/1972 6184 6184 6184 6184 135
22/05/1972 6185 6189 6185 6189 150
23/05/1972 6189 6189 6189 6189 266
24/05/1972 6189 6189 6189 6189 436
25/05/1972 6185 6185 6185 6185 276
26/05/1972 6187 6187 6186 6187 129
30/05/1972 6190 6190 6189 6190 289

Thank you.

air

End Of Month Data Only
 

DATE OPEN HIGH LOW CLOSE VOLUME
19720517 6180 6180 6180 6180 26
19720518 6182 6186 6182 6186 27
19720519 6182 6182 6182 6182 27
19720522 6182 6186 6182 6186 29
19720523 6186 6186 6186 6186 160
19720524 6186 6186 6186 6186 285
19720525 6182 6182 6182 6182 367
19720526 6184 6184 6184 6184 378
19720530 6186 6186 6186 6186 438
19720531 6186 6186 6186 6186 838
19720601 6186 6186 6186 6186 808
19720602 6178 6178 6178 6178 866
19720605 6180 6180 6178 6180 936
19720606 6177 6177 6175 6177 1077

Thanks a lot for the replay!

It is a spreadsheet of the Euro currency against Dollar. The condition
should accomplish the following:

If (some condition happen) then buy the Euro at the open of tomorrow
and close it at the last day of the current month.

Or

If (some condition happen) then sell the Euro at the open of tomorrow
and close it at the last day of the current month.

Thank you again.

air


--
air
------------------------------------------------------------------------
air's Profile: http://www.excelforum.com/member.php...o&userid=17272
View this thread: http://www.excelforum.com/showthread...hreadid=382637