Hi guys,
I'm sort of an amateur user of Excel just discovering more complicated functions, but I've hit a wall on a piece of work I'm doing.
Basically I'm working out a spreadsheet for an apartment company, and I need to be able to calculate number of days between two dates, divide the rent by that and work out how much was paid for the night.
I've managed to succeed with that, but I have a slight problem concerning dates between months, e.g. 28/08/2011 until 03/09/2011- I need to be able to work out what money was paid for August, i.e. the 28/08 to the 01/09 and then the monies paid in September for the rest of the month.
This also needs some kind of message to indicate the division between the two months.
I did try doing this the long way- working out the dates between the two months and then dividing the rent accordingly but it seems a bit convoluted, has anyone got any ideas?
Do I need to explain this better? Any help on the matter would be greatly appreciated.
Kindest regards
Skip08 (newbie)
Bookmarks