• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Reference a cell that already has a formula in it

tarynmahon

tarynmahon

Member
I have one cell that has an EOMONTH formula in, returning the number 3 (for March)

I have an offset formula that needs to use this number as the width, but because it is an EOMONTH formula, the Offset returns a #REF!, if I was to hard code the 3, my Offset formula works, how can I get this to work with the EOMONTH please?
 
Hi tarynmahon,


it should not do so, can you tell the formula you are using, and how you are getting 3 with EOMONTH formula.


Regards,
 
Good day tarynmahon


The Excel Eomonth function returns the last day of the month, that is a specified number of months before or after an initial supplied start date.


The syntax of the function is:


EOMONTH( start_date, months ) how do you get 3, it should return a date
 
You must log in or register to reply here.
Back
Top