Can someone point me in the right direction to create two formulas. The first formula I am trying to create is having Excel return the week number that corresponds to the month. For example, I want April 4th to display in a column as the 5th week of March.
The 2nd formula I am need help with is returning the month that corresponds to the calendar month. April 4th 2015 is part of March on the calendar if a new month always starts on a Sunday. Instead of April 4th showing in a Column as April, I want it to read March. Starting on Sunday April 5th, it would begin the Calendar month of April.
Any help would be greatly appreciated.
Thanks!
Bookmarks