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

Formula for YTD Average

Veeru106

Member
Hi,


I am looking for one formula which gives me Average of given range according to YTD level.


If my range is till Dec and My YTD is May then it should give me average till may and as I change my YTD to june next month it change accordingly.


Sheet attached for further reference.


Thanks
 

Attachments

  • New.xlsx
    9.3 KB · Views: 3
Veeru106
Year-to-date (YTD) is a period, starting from the beginning of the current year (either the calendar year or fiscal year) and continuing up to the present day.Do You have own YTD? or have You mixed some terms?
You do not have any dates in Your file.
 
Veeru106
one more time ...
1) Did You try to read my previous (#2) reply? ... blue part?
You have 'own YTD'... okay?
2) Why You won't use there dates instead of texts?
 
Ok yes, I am using YTD in Text like May instead of 5/30/2018…This is the requirement I have to use. We can use 5 instead of May but YTD till today is not possible as we are preparing report on one month lag..So In june I am working on May month file
 
Back
Top