Solved

excel formula

Posted on 2011-03-09
4
167 Views
Last Modified: 2012-05-11
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
0
Comment
Question by:Gazza83
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 39

Accepted Solution

by:
nutsch earned 250 total points
ID: 35089925
in C1
=DATE(YEAR(A1),MONTH(A1),1)

Thomas
0
 
LVL 81

Assisted Solution

by:zorvek (Kevin Jones)
zorvek (Kevin Jones) earned 250 total points
ID: 35089939
B1=A1-DAY(A1)+3-WEEKDAY(A1-DAY(A1)+1)+(1-(2>= WEEKDAY(A1-DAY(A1)+1))) * 7

Kevin
0
 
LVL 50
ID: 35089951
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
 
LVL 39

Expert Comment

by:nutsch
ID: 35089954
My take on B1
=MOD(9-WEEKDAY(DATE(YEAR(A1),MONTH(A1),1)),7)+DATE(YEAR(A1),MONTH(A1),1)

Thomas
0

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question