On Thursday, 6 May 2021 at 18:34:22 UTC+2, Claus Busch wrote:
Hi Norbert,
Am Thu, 6 May 2021 07:21:37 -0700 (PDT) schrieb Norbert:


Hi Claus,
E3 and H7:H18 are formatted as Date (mm-dd-yyyy) but this is the content of H7:H18

H7: =Settings!B5 it shows: 01-03-2021
H8: =H7+31 01-04-2021
H9: =H8+28 01-05-2021
H10: =H9+31 01-06-2021
H11: =H10+30 01-07-2021
H12: =H11+31 01-08-2021
H13: =H12+31 01-09-2021
H14: =H13+30 01-10-2021
H15: =H14+31 01-11-2021
H16: =H15+30 01-12-2021
H17: =H16+31 01-01-2022
H18: =H17+30 01-02-2022

On my settings sheet cell B5, I have the starting date of the tax year, which is always the 01.March
The formulas where I add the number of days is obviously not very clever but I didn't know better.
have a look:
https://1drv.ms/x/s!AqMiGBK2qniTgfBE...5Tugg?e=w0FUsg
Regards
Claus B.
--
Windows10
Microsoft 365 for business

Good morning Claus,
yes, that looks much better! I didn't know the end of month function. Very good, though.
There is no code in your file, isn't it? I couldn't find any.
I'm still having the problem that the code is not selecting the cell in range H7:H18 which has the same date
as cell E3. Am I missing something?

Regards,
Norbert