Titus,

Other problem?

Something like

=ROUND(Number of Rooms/Days in reference month*Days in new year,0)

So for Tuedays, you would have

=ROUND(22/4*5,0)

etc...

HTH,
Bernie
MS Excel MVP

> By the way, not that I want to press, but do you think you would have a
> "magical" solution to my other problem too?
>
> http://www.excelforum.com/showthread.php?t=467476
>
> Thanks for looking into it, should you have a moment. Hope to be able
> to provide some responses to this forum too, soon, not just ask dumb
> questions :-)
>
> Thanks again and greetings from Florence, Italy,
>
> Titus.
>
>
> --
> titushanke
> ------------------------------------------------------------------------
> titushanke's Profile: http://www.excelforum.com/member.php...o&userid=19997
> View this thread: http://www.excelforum.com/showthread...hreadid=469193
>