Solved

# Date help - EndOfMonth and a start date

Posted on 2014-10-20
79 Views
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
Question by:pdvsa
• 2
• 2

LVL 13

Expert Comment

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

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

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

anything else let me know...
0

LVL 27

Accepted Solution

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

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

## Featured Post

Question has a verified solution.

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

### Suggested Solutions

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,…
Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
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.