Forum Discussion
Macro that concatenates two cells, references a Date and then copy pastes value into first
Deleted
I added a formula to column L of the data tab to concatenate the month/day for today's month as an example of one way I believe what you're asking can be done.
I took the formula that JMB17 had written and modified it so that the result of the formula is actually a full date in Excel's date format. As you'll see, the condition in the first part of the IF function remains the same, but the rest, in my version, no longer uses concatenation; rather it uses the DATE function to take the numbers of day, month, and year, to produce the standard numeric value that the date format then turns into a date. This is then consistent with your dates for holidays, paydays, etc.
Here's the new formula, as it appears in cell L2.
=IF(OR(N2=MONTH(TODAY()),N2="xx"),DATE(YEAR(TODAY()),MONTH(TODAY()),O2),"")
I still have to say, however, that it's not clear to me what you're doing with the rest of the workbook. But if you can make this work, go for it.
