Skip sunday in Today()

[annadinesh]

Dear Experts

i have a date formula in a cell =today()

i want a formula or vba which skips the date of sunday and shows the date on monday of every month.


Please support


Regards


Dinesh Saha

 

[6StringJazzer]

Do you mean the cell always shows the date of the upcoming Monday?
Or it shows the current date, but on Sunday it shows the date of the next day (Monday)?

Sorry but "the date on monday of every month" doesn't make sense.

 

[annadinesh]

Do you mean the cell always shows the date of the upcoming Monday?
Or it shows the current date, but on Sunday it shows the date of the next day (Monday)?

Sorry but "the date on monday of every month" doesn't make sense.

SERVICE BOOKING REPORT 22.12.2023
No. of Call	SME NAME	No. of Booking	Booking Converted	Converted Ratio	Booking Not Reported
	BINITA SAHA	0	0	0%	0
BOOKING LIST 23.12.2023
SL No.	Customer Name	Regd. Number	Booking Number	SA Name	Reported Y/N
BOOKING LIST 24.12.2023

Like : in this sheet Booking List is showing of today that is 23.12.23

and iin 2nd list it was showing 24.12.2023 which is holiday of our office , i want it should shows 25.12.23 instead of 24.12.23

 

[6StringJazzer]

Your second date should refer to the first, rather than doing its own calculation.

Your mention of a holiday is still not consistent with your first post talking about Monday.

So I'll give you a formula that will give you the next day, unless the next day is a Sunday. In that case it will give you Monday.

=A4+1+IF(WEEKDAY(A4,16)=1,1,0)

It can be copied to the other days down below as long as each section has the same number of rows.

 

[Dave Patton]

What version of Excel are you using? Please edit your profile.
"Holidays" is a named range of holiday dates.
2 alternatives for you to review.

T202312a.xlsm
	A	B	C	D	E	F
1						Holidays
2		Sat 23-Dec-23				25-12-23
3		Sat 23-Dec-23
7e

Cell Formulas
Range	Formula
B2	B2	=LET(d,TODAY(),IF(WEEKDAY(d,2)=7,d+1,d))
B3	B3	=WORKDAY.INTL(TODAY()-1,1,11,Holidays)

Named Ranges
Name	Refers To	Cells
Holidays	='7e'!$F$2	B3