christmas

Hi All, I have the following formula =DATE(B50,12,25)+CHOOSE(WEEKDAY(DATE(B50,12,25)),1,0,0,0,0,0,2) which gives the date of the Christmas holiday. What I am trying to do in the next column is put a formula that will show Christmas Day if the date is the 25th December and Substitute Christmas...

<tbody> Holiday First Course Second Course Christmas EggNog Cookies Christmas EggNog Milk Christmas Spaghetti Bread Christmas Spaghetti Salad Christmas Meatballs Sauce Thanksgiving Turkey Corn Thanksgiving Turkey Veggies Thanksgiving MashedPotatoes Gravy Thanksgiving...

Hello! Have a question ... Here is my table <tbody> Christmas EggNog Christmas Spaghetti Christmas Meatballs Thanksgiving Turkey Thanksgiving MashedPotatoes Holiday? Options? Thanksgiving <tbody> =IFERROR(INDEX($A$1:$B$5,MATCH(ROW()-ROW($A$8),$A$1:$A$5,0)),"")...

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...

Tis the season for Christmas gift shopping and I'm trying to do a worksheet where I can do a lookup for items spent per person. It works fine when there is something listed for every person but, if nothing has been spent yet for a person, it returns "N/A." Is there someway I can alter the...

Hi All I have a spreadsheet with 10,000s of Theatre Box Office records. Each record is a count of the number of tickets sold by Show, Date, and Ticket Type. For example some records may look like this: <tbody> Show Type Show Name Performance Date Day Ticket Type Tickets Sold Christmas Show...

i All, Have come to a wall I'd love to de-brick...Not sure which function or how to solve this problem. I've a single sheet that contains the following... <colgroup><col style="mso-width-source:userset;mso-width-alt:3776;width:106pt" width="142"> <col...

It is that time of the year again... http://www.excelfox.com/forum/showthread.php/708-A-Blinking-Christmas-Tree

Hello, this is my first post here. Hope everyone is having a great day. I would greatly appreciate any help on this! I have data in an excel worksheet for a few dozen companies. It's a lot of data--more than you would manually want to sort though. The data describes business agreements that...