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