+ Reply to Thread
Results 1 to 4 of 4

how to get the date of the next sunday for ex?

  1. #1
    Forum Contributor juntjoo's Avatar
    Join Date
    02-29-2008
    Location
    Cape Coral, FL
    MS-Off Ver
    2007
    Posts
    340

    how to get the date of the next sunday for ex?

    that's all. How would you do that?
    Excel 2010

  2. #2
    Forum Guru
    Join Date
    02-27-2016
    Location
    Vietnam
    MS-Off Ver
    2010
    Posts
    4,502

    Re: how to get the date of the next sunday for ex?

    Try this: =WORKDAY.INTL(A1,1,"1111110")

    =WORKDAY.INTL(TODAY(),1,"1111110")

    or: =A1+8-WEEKDAY(A1)
    Last edited by Phuocam; 07-27-2020 at 12:16 AM.

  3. #3
    Forum Contributor juntjoo's Avatar
    Join Date
    02-29-2008
    Location
    Cape Coral, FL
    MS-Off Ver
    2007
    Posts
    340

    Re: how to get the date of the next sunday for ex?

    wow thanks. how did you perform that magic? or where's the 'thursday' in all that gibberish?

  4. #4
    Forum Contributor juntjoo's Avatar
    Join Date
    02-29-2008
    Location
    Cape Coral, FL
    MS-Off Ver
    2007
    Posts
    340

    Re: how to get the date of the next sunday for ex?

    might you know offhand how to convert 1/7/00 to 7?

    oh I got it. Number format

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Add Sunday date to file name
    By DeanMcK in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-04-2018, 08:49 PM
  2. Display a date for the following Sunday based off of current date
    By LeapingLizard in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 12-19-2017, 02:37 PM
  3. [SOLVED] calculate date but not sunday
    By daboho in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-17-2015, 02:56 AM
  4. move date to next Monday if date is on a Friday, Saturday or Sunday
    By ea223 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-24-2014, 01:54 PM
  5. Change date to the following Sunday
    By pilotwings64 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-26-2008, 06:34 PM
  6. Check to see if date is = to Sunday
    By Brian in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-18-2006, 10:25 PM
  7. Check to see if date is = to Sunday
    By Brian in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-18-2006, 10:00 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