I am Using excel 2007 and running Windows 7 Pro. I have 50 Thousand rows with data.
I am trying to do a merge of different cells to create a title, One of the cells that I need to merge is an upcoming holiday. I have 4 columns of holidays.
For example: Today's date is 5/22/2015 next upcoming holiday would be Memorial Day and after that would be Father's Day.
So, from Today's date to Memorial day the title would contain "Memorial Day" After memorial day, I want the formula to automatically replace "Memorial day" with "Father's Day" And doing the same to upcoming holidays after that.
I have researched forums and gotten ideas to compose a formula. I was able to create one, but the only way I got it to work was with the holiday's date instead of there name. If there is no other way of doing it besides that way I would be okay with it.
Only thing i'm concerned about is Opening, Saving, and Editing a file that large with a formula that big is very time consuming and un-responsive sometimes. I need help and would like to have a formula that dose what I need more efficiently and quicker. ideas on shortening the formula
Here is my formula:=IF(SMALL(IF($A$2:$A$7>TODAY(),$A$2:$A$7),1)=DATE(YEAR(TODAY()),2,14),"Valentine's Day",IF(SMALL(IF($A$2:$A$7>TODAY(),$A$2:$A$7),1)=DATE(YEAR(TODAY()),4,5),"Easter Day",IF(SMALL(IF($A$2:$A$7>TODAY(),$A$2:$A$7),1)=DATE(YEAR(TODAY()),5,10),"Mother's Day",IF(SMALL(IF($A$2:$A$7>TODAY(),$A$2:$A$7),1)=DATE(YEAR(TODAY()),6,21),"Father's Day",IF(SMALL(IF($A$2:$A$7>TODAY(),$A$2:$A$7),1)=DATE(YEAR(TODAY()),10,31),"Halloween",IF(SMALL(IF($A$2:$A$7>TODAY(),$A$2:$A$7),1)=DATE(YEAR(TODAY()),12,25),"Christmas"))))))
I have dates in Array A2:a7
Thanks in advance for any help, tips, and ideas.
I am trying to do a merge of different cells to create a title, One of the cells that I need to merge is an upcoming holiday. I have 4 columns of holidays.
For example: Today's date is 5/22/2015 next upcoming holiday would be Memorial Day and after that would be Father's Day.
So, from Today's date to Memorial day the title would contain "Memorial Day" After memorial day, I want the formula to automatically replace "Memorial day" with "Father's Day" And doing the same to upcoming holidays after that.
I have researched forums and gotten ideas to compose a formula. I was able to create one, but the only way I got it to work was with the holiday's date instead of there name. If there is no other way of doing it besides that way I would be okay with it.
Only thing i'm concerned about is Opening, Saving, and Editing a file that large with a formula that big is very time consuming and un-responsive sometimes. I need help and would like to have a formula that dose what I need more efficiently and quicker. ideas on shortening the formula
Here is my formula:=IF(SMALL(IF($A$2:$A$7>TODAY(),$A$2:$A$7),1)=DATE(YEAR(TODAY()),2,14),"Valentine's Day",IF(SMALL(IF($A$2:$A$7>TODAY(),$A$2:$A$7),1)=DATE(YEAR(TODAY()),4,5),"Easter Day",IF(SMALL(IF($A$2:$A$7>TODAY(),$A$2:$A$7),1)=DATE(YEAR(TODAY()),5,10),"Mother's Day",IF(SMALL(IF($A$2:$A$7>TODAY(),$A$2:$A$7),1)=DATE(YEAR(TODAY()),6,21),"Father's Day",IF(SMALL(IF($A$2:$A$7>TODAY(),$A$2:$A$7),1)=DATE(YEAR(TODAY()),10,31),"Halloween",IF(SMALL(IF($A$2:$A$7>TODAY(),$A$2:$A$7),1)=DATE(YEAR(TODAY()),12,25),"Christmas"))))))
I have dates in Array A2:a7
Thanks in advance for any help, tips, and ideas.