As birthdays are an exciting time of celebration, planning for the big day often takes quite some time. Knowing your next birthday is a must if you intend on getting the most out of that special day. However, while it may take some contemplating to determine the exact date of your upcoming birthday, there is a simple and straightforward way to calculate your next birthday – all you need is a simple mathematical calculation.
The fastest and easiest way to find out when your next birthday will be is to subtract the current year from the year you were born plus one year. In other words, if you were born in 2000, 2020-2000+1 = 2021. Meaning your next birthday is in 2021. For example, if someone's birthdate was on April 6th 1996: 2021-1996+1 = 26 April 2022 (the upcoming birthday).
Furthermore, another approach for calculating one's next birthday date would be using the weekday function of Excel or any other spreadsheet tools to compare the two dates; birth date and current date. This way of calculation provides more accuracy when compared to using straight mathematics as Excel handles leap years accurately. With this method, simply enter the two dates into respective columns and use the weekday function with those two dates as arguments (e.g.,=DATE(A2-B2+1;B3;B4)). This will give you a result which reads "Sunday" (or any other day) which corresponds to your upcoming birthday date.
See more about birthday calculator
No comments:
Post a Comment
Note: Only a member of this blog may post a comment.