Results 1 to 6 of 6

Get the month as text in cell from formula

Threaded View

graiggoriz Get the month as text in cell... 07-15-2013, 08:41 AM
Debraj Roy Re: Month 07-15-2013, 08:43 AM
Fotis1991 Re: Month 07-15-2013, 08:45 AM
Debraj Roy Re: Month 07-15-2013, 08:45 AM
Pepe Le Mokko Re: Month 07-15-2013, 09:04 AM
arlu1201 Re: Month 07-15-2013, 09:07 AM
  1. #1
    Forum Contributor
    Join Date
    02-21-2007
    MS-Off Ver
    Microsoft 365 Apps for enterprise
    Posts
    389

    Get the month as text in cell from formula

    hello,

    I need to get the month in a cell. I tried in A1 =NOW() in B1 =MONTH(A1) and I would need in C1 to use a IF formula to get the month but I would need to do =IF(B1=1,"JANUARY","")

    So my questions:

    1) how do you do to use the if formula 12 times? (EG: =IF(B1=1,"JANUARY","")AND IF B1=2, "FEBRUARY" ???

    2) Is there any better way to get the month :-P

    Thanks,
    Graig
    Last edited by graiggoriz; 07-19-2013 at 05:34 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Caclulate month of quarter (1st month - 3rd month)
    By kuraitori in forum Excel General
    Replies: 5
    Last Post: 07-15-2018, 03:53 PM
  2. Changing number of days in a month based on month chosen from a dropdown list.
    By st_judeu@yahoo.com in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 02-08-2013, 02:26 PM
  3. [SOLVED] Auto populate cells from data in a 6 month range starting with the current month
    By ecarnley349 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-21-2012, 07:32 PM
  4. Replies: 4
    Last Post: 03-19-2012, 08:58 AM
  5. [SOLVED] Pivot: Replace month numbers with month names and sort by fiscal year
    By jomili in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-29-2011, 02:13 PM

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