newtoexcelvab
New Member
- Joined
- Dec 11, 2012
- Messages
- 4
I have a spreadsheet that has a tab for everyday of the month> I would like for each tab to read day of week, month of year and the date of that particular day
for example
sheet(1)= Tue Jan 01
sheet(2)=Wed Jan 02
sheet(3)=Thu Jan 03
and so on until
sheet(31)= Thu Jan 31
I am new to excel and to vba, so all information as to where at in the coding I need insert provided coding is very much appreciated?
thanks in advance for any and all help that you forum readers can give.
for example
sheet(1)= Tue Jan 01
sheet(2)=Wed Jan 02
sheet(3)=Thu Jan 03
and so on until
sheet(31)= Thu Jan 31
I am new to excel and to vba, so all information as to where at in the coding I need insert provided coding is very much appreciated?
thanks in advance for any and all help that you forum readers can give.