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
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
I suggest using TODAY instead of NOW if you just care about the date and not the time:
Formula:
Please Login or Register to view this content.
Another option.Formula:
Please Login or Register to view this content.
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks