Finding Christmas Day

[paulsolar]

Hi All

I've been on this all afternoon and have finally given up.

In column B I have dates and in column C I have the opening hours off the office.

I can figure out how to find the date of Christmas (25-Dec ) if I have the year to go with it, for example 25-Dec-2019. What I cant figure out is how to find the 25-December for every year in the date column.

What I'm attempting to do is loop through all the dates in column B and if it's Christmas day in corresponding cell in column C enter "Closed" There may already be information in column C that needs to be overwritten.

Without being able to do this I have to I cant automate an upload automatically to a website calendar.

Any help or ideas of a method of doing this would be greatly appreciated.

cheers

Paul

 

[rlv01]

Earlier you described the contents of columns A-C as

Col A = Day of the week 'Example = Wednesday
Col B = Dates (excel dates, not date strings) 'Example = 12/15/2013
Col C = column C has the opening hours dependant on the day of the week 'Example = Closes: 09:59 Reopens: 12:59

Then a formula like this in column D (or wherever) should more or less do what you want, yes?

=A1 & " " & TEXT(B1,"mm-dd-yyyy") & ", " & IF(MONTH(B1)&DAY(B1)="1225","Closed For Christmas",C1)

 

[paulsolar]

hi rlv

thats sorted it.

I've no idea why the others dont work, but my mind is fried and boiled, I'll check it out again tomorrow, but for now i have a solution

cheers

Paul