Hi
I need to create reports of calls logged to a customer on a month basis, however they have requested that the bills are from the start of the contract date. so basically they want billing from the 5th of the month to the 4th of the next month. but still have graphs and tables show the month. there January runs from 5th January to 4th February, February runs from 5th of febuary to 4th march etc. is there a formula that if I have a spare column I can rename these lines in excel to the month based on the date as above mentioned.
I need to create reports of calls logged to a customer on a month basis, however they have requested that the bills are from the start of the contract date. so basically they want billing from the 5th of the month to the 4th of the next month. but still have graphs and tables show the month. there January runs from 5th January to 4th February, February runs from 5th of febuary to 4th march etc. is there a formula that if I have a spare column I can rename these lines in excel to the month based on the date as above mentioned.