Results 1 to 6 of 6

Pulling of month & year from date cell

Threaded View

  1. #1
    Forum Contributor
    Join Date
    07-21-2009
    Location
    Kuwait
    MS-Off Ver
    Excel 2019
    Posts
    292

    Thumbs up Pulling of month & year from date cell

    Hi all,

    i have attached a sheet, i want if i put date in cell a2 and automatically month should come in cell b2 and year in c2,

    LIKE JAN AND 2009 LIKE THAT..

    pls go throuh my sheet and do help,

    and also if it is possible, pls do that i want total of each folder and account in sheet2..

    Thanks in advance..

    Test.xls
    Last edited by tariqnaz2005; 12-02-2009 at 10:40 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1