Results 1 to 7 of 7

How to arrange the number of the year and month according to cell A1

Threaded View

  1. 01-02-2022, 07:10 PM #1
    choletseng
    choletseng is offline
    Forum Contributor
    Join Date
    10-02-2021
    Location
    Thailand
    MS-Off Ver
    365
    Posts
    192

    How to arrange the number of the year and month according to cell A1

    The number must be from Sunday to Saturday

    The yellow area is the final result

    C4:I9 How to write formula

    Can someone please help me ? It would be much appreciated. Thanks in advance
    Attached Files Attached Files
    Last edited by choletseng; 01-02-2022 at 08:13 PM.
    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. conditional format for cell contain number of year month and days
    By mazan2010 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-15-2021, 09:35 AM
  2. Extracting Date (year,month,day) from cell with Date (year,month,day,time)
    By TheRobsterUK in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-16-2020, 01:58 PM
  3. [SOLVED] How to convert month and year to the number of the month
    By parsenov in forum Excel General
    Replies: 3
    Last Post: 12-10-2019, 04:57 PM
  4. Extract month number and year
    By Howardc1001 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-28-2019, 12:28 PM
  5. Running Totals from 24 hours to month, month to year without year decreasing
    By Safetyintern in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-20-2015, 01:13 PM
  6. If Column A Month and Year = ColumnB Todays Month and Year then send email
    By HACCStaff in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-15-2013, 12:47 AM
  7. [SOLVED] display cell to show only Month/year to do sumif calc if today()= any day of month
    By fireguy7 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-12-2013, 06:55 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