Hi,
We have a requirement where the user enters the month and year as input.
If user enters 04.2008 means my formula should be like
YTD= total employee Quit/
(Opening Headcount of april1st2008Closing Headcount of April end 2008)/2
)/N*365/No of days elapsed * 100
and If user enters 05.2008 the formula should be
YTD= total employee Quit/
((Opening Headcount of april1st2008Closing Headcount of April end 2008)/2
(Opening Headcount of may 1st 2008 + closing Headcount of May end 2008)/2 ))/N*365/No of days elapsed * 100
April 2008 wil always be the starting of calculation
Can anyone please tell how we can achieve this type of dynamic formula ?
Thanks in Advance