Results 1 to 8 of 8

Days of the month and week based on name month/year

Threaded View

  1. 08-31-2016, 11:09 PM #5
    protonLeah
    protonLeah is offline
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,936

    Re: Days of the month and week based on name month/year

    A1 --> 03/2028, formatted as DD/YYYY
    D2 --> =A1, formatted as dd
    E2:AH2 --> =IFERROR(IF(MONTH(D$2+1)=MONTH($A$1),$A$1+COLUMN()-4,""),"")
    D3:AH3, --> =D2
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Formula for counting rain days of the year, month, and or week
    By dedark05 in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 05-24-2016, 01:27 AM
  2. [SOLVED] Calculate Week Range from Week Number, Month and Year?
    By A108A108 in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 05-07-2016, 03:11 PM
  3. [SOLVED] Determine work days in current month or next month based on day of the month
    By sbrnard in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 05-29-2014, 05:14 PM
  4. find time left in month.days unit between two dates(in YEAR.MONTH.DAY)
    By xcfeng95 in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 02-21-2014, 12:55 PM
  5. Return value of the last week of the month based on the year and month
    By stevekho2 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-14-2013, 11:04 AM
  6. 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
  7. [SOLVED] Auto fill week days based on month chosen
    By mteeters in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 11-14-2012, 02:45 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1