Hi
I want to populate in excel for the complete month in the following way
Column A Column B
01/11/2014 Saturday
02/11/2014 Sunday
Hi
I want to populate in excel for the complete month in the following way
Column A Column B
01/11/2014 Saturday
02/11/2014 Sunday
Hi,
in A2 date, in B2:
orPlease Login or Register to view this content.
Please Login or Register to view this content.
Hope it helps
Last edited by canapone; 10-31-2014 at 02:48 AM.
-----------------------------------------------------
At Excelforum, you can say "Thank you!" by clicking the star icon ("Add Reputation") below the post.
Please, mark your thread [SOLVED] if you received your answer.
Hi again,
you could also customize format in column A
dd/mm/yyyy dddd
You' d get visually same informations from dates.
Cheers
Put a1 in column A and Saturday in column b, select both cells, and drag it down using fill handle (a small + like symple in bottom right)
☚ Click ★ just below left if it helps, Boo?ath?
Try this attached file
Hope this will help u
Thanks - Naveed
-----------------------------
If the suggestion helps you, then Click * to Add Reputation
To Attach File: Go Advanced>>Manage Attachments>>Add Files (In Top Right Corner)>>SelectFiles>>.........Locate Your File(s)>>Upload Files>>Done (In Bottom Right)
1. Use [code] code tags [\code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.
2. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks