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