How to write down the cost of every 10 weeks by March 31 Formula

[GVN KUMAR]

We have prepared 80% of the project for the Poultry Farm Unit.
The remaining 20% are waiting for your help.

The data will be available from April 1 to March 31, according to the Indian financial year There are 3 types of processes by which chickens lay eggs

10 weeks in the brooder cage from the date of purchase

After 10 weeks in the Grover cage comes the still 20 weeks of age

The hen lays eggs for up to 52 weeks We then sell the chicken for meat.

These are all formulas but the calculations are calculated according to the dates we have entered but not according to the financial year.

This means that if you want a stage for 10 weeks, that stage starts on 9-2-23 and ends on 20-4-23 Then the formula we laid out is only counting up to 9-2-23 not considering 31-3-23 Each stage must be considered by March 31st which means writing any formula

How much is the cost of the cost we have in the stage of the formula

 

[Moom1]

Concatenate and vlookup use?

 

[Peter Bartholomew]

The attached shows an approach to calculating the overlap between a set of intervals such as those rearing batches of chicks and financial years. There is little point in my refactoring your workbook because the methods I use are not those that you would use.
You will find that more specific and narrowly focussed Excel questions are more likely to get a response.
Anyway, in case it helps, the approach I take to calculating overlapping time periods and associated costs is to subtract the later start-time from the earlier end-time. If the result is positive, go with it; if it is negative the ranges do not overlap so replace negative intervals by zero.

 

[GVN KUMAR]

మా సమస్యను పరిష్కరించడానికి మీ విలువైన సమయాన్ని కేటాయించినందుకు ధన్యవాదాలు.

వెరీ నైస్ సర్, మొదటి స్టెప్ కొరకు మీరు ఇచ్చిన ఫార్ములా 100000% కచ్చితత్త్వంతో సరిపోతుంది.

మీరు ఈ తేదీలకు లింక్ చేస్తే, రెండవ మరియు మూడవ దశలకు కూడా ఇది సరిపోతుందా, సర్?

ఈ ప్రశ్నకు అసలు సమాధానం వస్తుందని మేము ఊహించలేదు.

చాలా ధన్యవాదాలు
25 రోజుల నుంచి మావల్ల సర్ ని బుజ్జగించలేకపోయాం.

మేము SUMIF ఫంక్షన్ తో బ్యాచ్ తేదీలను జోడించాము
మేము సంవత్సరం గడిచిపోయిన విషయాల యొక్క మరొక బ్యాచ్ ను రాశాము, సర్.

సర్, మీరు రాసిన ఫార్ములా చాలా గైడింగ్ గా ఉంది మరియు దీనిని చాలా తేలికగా ప్రజంట్ చేయవచ్చు సర్

మేము మీకు చాలా ధన్యవాదాలు తెలియజేస్తున్నాము

మీరు రాసిన ఈ ఫార్ములా చాలా ఉపయోగకరంగా ఉంటుంది.

 

[GVN KUMAR]

Thank you for taking your valuable time to solve our problem. Very nice sir, the formula you have given for the first step is 100000% accurate. If you link to these dates, will it fit into the second and third steps as well, sir? We did not expect an actual answer to this question. Thank you very much We have not been able to appease Mavalla Sir for 25 days. We have added batch dates with SUMIF function We wrote another batch of things that went through the year, sir. Sir, the formula you have written is very guiding and can be presented very easily sir We thank you very much This formula you have written is very useful.