Solved

Date help - EndOfMonth and a start date

Posted on 2014-10-20
5
75 Views
Last Modified: 2014-10-20
How can I modify the below to start on a named range (ie Start date)?  Meaning until we reach the Start Date then it will not return any date or  a "-" might be more appropriate (not sure what is best)

=EOMONTH(TODAY(),0)+2

thank you
0
Comment
Question by:pdvsa
  • 2
  • 2
5 Comments
 
LVL 13

Expert Comment

by:akb
ID: 40393013
=+IF(EOMONTH(TODAY(),0)+2>=A1,EOMONTH(TODAY(),0)+2,"-")
Put the date you want to start on in cell A1
0
 
LVL 27

Expert Comment

by:Glenn Ray
ID: 40393043
This still isn't clear to me.  

You have a cell with the named range "StartDate".  This could be any date, not necessarily the begining of any month.

You want a formula to return "-" until today's date matches StartDate.  

What exactly do you expect the value to return on/after the StartDate?  Your formula appears to report the second day of the following month.  Is that correct?  You don't want the first day of the following month?  Like this?
=IF(TODAY()>=StartDate,EOMONTH(TODAY(),0)+1,"-")
0
 

Author Comment

by:pdvsa
ID: 40393057
Glenn, its actually 2 days after EOM.  

anything else let me know...
0
 
LVL 27

Accepted Solution

by:
Glenn Ray earned 500 total points
ID: 40393072
If it's two days, then:
=IF(TODAY()>=StartDate,EOMONTH(TODAY(),0)+2,"-")
0
 

Author Closing Comment

by:pdvsa
ID: 40393134
thank you.  Note that the first answer did not have a named range
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

706 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now