• 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.

Date with Dates

polimetla gopal

New Member
Dear all,

I am Gopal. First Post.

I am constructing an excel model where Launch of a product into market is entered as date.
Based on the date entered, excel should fill in next 36 month names and exact days of those months.

Help!

Thank you in advance
gopal.
 
Hi Gopal ,

Your information is inadequate ; please give more information , and if possible , upload a sample workbook with at least one manually worked out example.

Narayan
 
Hi:
Not sure what you are looking for. I took a wild guess, find the attached.

Thanks
 

Attachments

  • Copy of sample calculation.xlsx
    9 KB · Views: 13
Hi ,

I always insist on developing a formula using helper cells / columns , so that the logic of the formula can be verified ; trying to develop a single-cell formula should be through a fool-proof algorithm.

See the attached file for this method , which seems to give different results.

Narayan
 

Attachments

  • Copy of sample calculation.xlsx
    13.4 KB · Views: 7
Hi ,

I always insist on developing a formula using helper cells / columns , so that the logic of the formula can be verified ; trying to develop a single-cell formula should be through a fool-proof algorithm.

See the attached file for this method , which seems to give different results.

Narayan

Thank you Narayan.
 
Back
Top