Excel Formula or Function Help - Date

wazupsc

New Member
Joined
Jul 19, 2010
Messages
8
I do invoices every Wensedays. I there a way for excel to put Wenseday date of the week ahead?
 

Some videos you may like

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.

VoG

Legend
Joined
Jun 19, 2002
Messages
63,650
Try

=TODAY()+6-MOD(TODAY()+2,7)

Format as Date.
 

Subscribe on YouTube

Watch MrExcel Video

Forum statistics

Threads
1,105,950
Messages
5,508,324
Members
408,678
Latest member
ripperbolt

This Week's Hot Topics

Top