Hi,
Honestly with this site, I am gaining knowledge, but have to agree I have become lazy. My logical thinking capacity has reduced, as I have started resorted to short cut solutions from experts here
Well, here comes my another problem.
I am working on YTD calculation for attrition, for which I would need number of days between start of the financial year and end of this month.
eg: for today, 7th Feb 2012, begining of the year is 01-Apr-2011 and will continue to be same until 31 mar 2012. From Apr 2012 to Mar 2013 01-Apr-2012 will be the begining of the year.
So I decided to define "BOY" (Begining of Year) using the formula like this:
=DATE(YEAR(TODAY())-IF(MONTH(TODAY())<4,1,0),4,DAY(1))
I then use EOMonth((today(),0) - BOY to get number of days between start of year and end of this month.
I also verified they are working perfectly correct, but I am not convinced if I am using right methods.
Am I doing anything wrong here, i mean tedious method rather than using any inbuilt functions?
Regards,
Prasad DN
PS: Apologies for the lengthy post
Honestly with this site, I am gaining knowledge, but have to agree I have become lazy. My logical thinking capacity has reduced, as I have started resorted to short cut solutions from experts here
Well, here comes my another problem.
I am working on YTD calculation for attrition, for which I would need number of days between start of the financial year and end of this month.
eg: for today, 7th Feb 2012, begining of the year is 01-Apr-2011 and will continue to be same until 31 mar 2012. From Apr 2012 to Mar 2013 01-Apr-2012 will be the begining of the year.
So I decided to define "BOY" (Begining of Year) using the formula like this:
=DATE(YEAR(TODAY())-IF(MONTH(TODAY())<4,1,0),4,DAY(1))
I then use EOMonth((today(),0) - BOY to get number of days between start of year and end of this month.
I also verified they are working perfectly correct, but I am not convinced if I am using right methods.
Am I doing anything wrong here, i mean tedious method rather than using any inbuilt functions?
Regards,
Prasad DN
PS: Apologies for the lengthy post