Tagged with days-in-month - Visokio Forums http://forums.visokio.com/discussions/tagged/days-in-month/feed.rss Mon, 30 Oct 17 20:05:02 -0400 Tagged with days-in-month - Visokio Forums en-CA Formulae: No. days in a month given start/end date? http://forums.visokio.com/discussion/1923/formulae-no.-days-in-a-month-given-startend-dates Wed, 28 Nov 2012 12:24:09 -0500 ALC 1923@/discussions
So inputs are
spend= £10,000
start date: 30/10/2012
end date: 03/11/2012

Output I need
spend in Oct: £4,000 [obtained from £10,000/5 (total number of days)*2 (number of days in Oct)]
spend in Nov: £6,000 [obtained from £10,000/5 (total number of days)*3 (number of days in Nov)]

Thanks
Anna
]]>