+ Reply to Thread
Results 1 to 4 of 4

=NOW() function returning the next Sunday

  1. #1
    Registered User
    Join Date
    07-17-2008
    Location
    London
    Posts
    1

    =NOW() function returning the next Sunday

    Can anyone assist me in how i can auto populate a field to return the next SUNDAY from NOW.

    Just to explain if today's date is 04OCT21 the formula would need to return 10OCT21.

    TIA

  2. #2
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    21,128

    Re: =NOW() function returning the next Sunday

    I suggest using TODAY instead of NOW if you just care about the date and not the time:

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    12,387

    Re: =NOW() function returning the next Sunday

    Another option.
    Formula: copy to clipboard
    Please Login or Register  to view this content.

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    62,050

    Re: =NOW() function returning the next Sunday

    This has been posted in the Outlook section - is it an Outlook query or an Excel one?
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" to anyone who has offered you help in your thread. You can reward them by clicking on * Add Reputation below theur user name on the left, if you wish.


    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.

+ 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] How to omit holidays and Sunday in DateDiff function
    By mohan.r1980 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 12-23-2017, 01:54 AM
  2. [SOLVED] skip row if other cell is sunday using If function
    By vsravi.kmb in forum Excel General
    Replies: 10
    Last Post: 10-02-2014, 10:31 PM
  3. code with Format function, first day of week as monday not sunday
    By KEVSTEF in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-29-2012, 02:51 PM
  4. date function which did not include sunday
    By Harrold in forum Excel General
    Replies: 12
    Last Post: 11-03-2011, 12:06 PM
  5. Function to Ignore Saturday and Sunday
    By kamalthakur in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-08-2008, 11:34 AM
  6. WORKDAY function should take only sunday as non working day
    By irfanch in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-26-2008, 06:00 AM
  7. [SOLVED] Sunday Function
    By Sunday Function in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-07-2006, 03:15 AM

Tags for this Thread

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