Total Number of Days in a Month | Excel Formula | Learn Excel

Sir I get 31.01.1990 by using the same formula.. why?? I'm using office 2019. Kindly guide

Kind suggestion from Canada - instead of dragging down you can simply double click at the right bottom place of the top cell (when small cross sign shows up during hoovering). It will automatically fill all cells below the top one.
Thank you for your videos and sharing your knowledge.