excel formula

IF A1 =Today()

Is there a formula I can place in:-

B1 - To equal the very first Monday of the given month
C1 - The first day
Gazza83Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
nutschConnect With a Mentor Commented:
in C1
=DATE(YEAR(A1),MONTH(A1),1)

Thomas
0
 
zorvek (Kevin Jones)Connect With a Mentor ConsultantCommented:
B1=A1-DAY(A1)+3-WEEKDAY(A1-DAY(A1)+1)+(1-(2>= WEEKDAY(A1-DAY(A1)+1))) * 7

Kevin
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
With C1 established by Thomas' formula, you can use in B1

=C1+MOD(8-WEEKDAY(C1,2),7)

or

=C1+IF(2 < WEEKDAY(C1), 7 - WEEKDAY(C1) + 2, 2 - WEEKDAY(C1))

cheers, teylyn
0
 
nutschCommented:
My take on B1
=MOD(9-WEEKDAY(DATE(YEAR(A1),MONTH(A1),1)),7)+DATE(YEAR(A1),MONTH(A1),1)

Thomas
0
All Courses

From novice to tech pro — start learning today.