Friday solver

[Joe Carrigan]

Hi all. I seem to be banging my head against a wall with something which I imagine should be simple.
basically I need a formula that solve the following;
If today is a friday before 12:00, return todays date and 12:00. If it has passed 12:00, then return next fridays date at 12:00.
Thanks in advance.

 

[Dave Patton]

T202104a.xlsm
	A	B
1
2	22-04-21
3	Fri 23-Apr-21 11:55	Fri 23-Apr-21 12:00
4	Fri 23-Apr-21 21:55	Fri 30-Apr-21 12:00
5
2f

Cell Formulas
Range	Formula
A2	A2	=TODAY()
B2:B4	B2	=IF(WEEKDAY(A2)=6,IF(MOD(A2,1)<0.5,INT(A2)+0.5,INT(A2)+7.5),"")

 

[Toadstool]

Hi JoeCarrigan,

Try

=IF(AND(WEEKDAY(TODAY(),15)=1,NOW()-INT(NOW())<0.5),TODAY()+0.5,TODAY()+8-WEEKDAY(TODAY(),15)+0.5)