In: Economics
In Dominica, December 25 is Christmas. Given a year that a user enters, have your spreadsheet determine the date of Christmas. For example, if the user enters2030 as the year, your spreadsheet should display the date of Christmas is format 2030: Wd-Dec25. The formula should not display data is entered.
I have assumed that year will be entered in Cell A1 and result is required in Cell B1.
We can get the result by using the below mentioned formula in Cell B1.
=IF(A1="","",A1&": "&TEXT(DATE(A1,12,25),"ddd")&" - "&TEXT(DATE(A1,12,25),"mmm dd"))
Below is the screenshot of the formula in excel -
Below is the result as desired -