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" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks