VBA - number of monthdays ...

[Mirja]

Hello!

I would like to change the follwoing command:

dbentry = Day(DateSerial(Year(Date), Month(Date) + 1, 0))
* 24

Excel should take the number of days of the month "two
days ago" (e.g. today is March 2nd, Excel should take
number of days in February). My problem is that data from
the previous month needs to be calculated on 1st and 2nd
of the current month ...

Can anybody help?

Thank you,
Mirja

[Niek Otten]

Hi Mirja,

Just leave out the "+1"

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"Mirja" <[email protected]> wrote in message
news:[email protected]...
> Hello!
>
> I would like to change the follwoing command:
>
> dbentry = Day(DateSerial(Year(Date), Month(Date) + 1, 0))
> * 24
>
> Excel should take the number of days of the month "two
> days ago" (e.g. today is March 2nd, Excel should take
> number of days in February). My problem is that data from
> the previous month needs to be calculated on 1st and 2nd
> of the current month ...
>
> Can anybody help?
>
> Thank you,
> Mirja

[Harald Staff]

Hi Mirja

Day(DateSerial(Year(Date-2), Month(Date-2) + 1, 0))

You are not multiplying a date by 24 ?

HTH. Best wishes Harald


"Mirja" <[email protected]> skrev i melding
news:[email protected]...
> Hello!
>
> I would like to change the follwoing command:
>
> dbentry = Day(DateSerial(Year(Date), Month(Date) + 1, 0))
> * 24
>
> Excel should take the number of days of the month "two
> days ago" (e.g. today is March 2nd, Excel should take
> number of days in February). My problem is that data from
> the previous month needs to be calculated on 1st and 2nd
> of the current month ...
>
> Can anybody help?
>
> Thank you,
> Mirja