Hi guys
i am told the only way i can achieve what i really need is a vba script but im clueless
so i am wondering if one of you really smart guys can help me out.
i have a worksheet that contains 3 tabs.
column A > I contain data entry fields however. Column J > AO contain Dates. sort of. there forumulated using =EOMONTH(AW1,0) and then counting back 31 days. .. So AO contains =EOMONTH(AW1,0) (31/03/2016) etc..
what i am trying to achieve is Column J check todays date and show the Week begining Date (always a monday) and then the rest of the month along the colums at the top (hiding anything before or after the 31 days
So column J would always be a monday. but would update every week as would the the columns after it.
i am told the only way i can achieve what i really need is a vba script but im clueless
so i am wondering if one of you really smart guys can help me out.
i have a worksheet that contains 3 tabs.
column A > I contain data entry fields however. Column J > AO contain Dates. sort of. there forumulated using =EOMONTH(AW1,0) and then counting back 31 days. .. So AO contains =EOMONTH(AW1,0) (31/03/2016) etc..
what i am trying to achieve is Column J check todays date and show the Week begining Date (always a monday) and then the rest of the month along the colums at the top (hiding anything before or after the 31 days
So column J would always be a monday. but would update every week as would the the columns after it.