Jump to content

Hitta datum i Excel. (Antalet dagar i månad under en period)


Recommended Posts

hejhej.

Jag har ett problem. Jag försöker få ut antalet bokade dagar under en period baserat på månader...

X1, 2010-01-30 --> 2010-06-30 (cost=$2/h)

X2, 2010-02-10 --> 2010-12-31 (cost=$4/h)

X3, 2010-04-15 --> 2010-10-28 (cost=$2/h)

Jag vill alltså få ut bokningsinformationen på:

X1, january (2days(24h*2d*$2)),

X1, Febuary (28days(24h*28d*$2)),

X1, March (31days(24h*31d*$2)),

Och så vidare.... till Juni

X2, january (0days(0h*0d*$4)),

X2, Febuary (19days(24h*19d*$4)),

X2, March (31days(24h*31d*$4)),

X2, April (30days(24h*30d*$4)),

Och så vidare.... till April

X2, january (0days(0h*0d*$2)),

X2, Febuary (0days(0h*0d*$2)),

X2, March (0days(0h*0d*$2)),

X2, April (30days(24h*30d*$2)),

Och så vidare.... till Oktober

I want to display the no of days per month including the 'zero' days. And the booking may change, so one day it could be from April, the next day it could very well be from february.

Please help. See the snap of the workbook.

6886ec5e54.jpg[/img]

bokningar.xls

Tacksam för hjälp.

/ Christofer

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

×
×
  • Create New...