Hi Norbert,
Am Thu, 1 Dec 2022 19:55:56 +0200 schrieb Norbert:
> could someone please help me with a formula?
> On sheet "database", I enter the date of the first date of a month, e.g.
> 01/11/2022 into cell D2
> On sheet "performance" cell N3 is looking up this date from sheet
> "database" by this formula: =Database!D2
>
> I need a formula for sheet "performance" for the cells A3 up to M3,
> displaying the first date of the previous months to the month displayed
> in cell N3.
>
> Eg: N3 displays 01/11/2022
> M3 should display 01/10/2022
> L3 should display 01/09/2022
> K3 should display 01/08/2022
> and so on.
in M3 try:
=EDATE($N$3,-COUNT($N3:N3))
and drag to the left.
Regards
Claus B.
--
Windows11
Microsoft 365 for business