This time the challenge is – If a date is given, what would be the formula to find the number of days passed in a quarter.
If A1 has the value 12-Mar-16, then 31 days in Jan, 29 days in Feb (2016 is a leap year) and 11 days in Mar = 31+29+11 = 71 days have passed in Q1. Hence, answer is 71.
If A1 has 15-Apr-16, then 14 days have passed in Q2. Hence, answer is 14.
If A1 has 28-Aug-16, then, 31 days in Jul and 27 days in Aug = 31+27 = 58 days have passed in Q3. Hence, answer is 58.
You need to give the formula to find the above.
The solution to above challenge will be published after a month i.e. on 18-Jul-16.