working with dates in excel

[boschuster50]

I previously posted a question.

I have column A with dates, column B with different dates...
My formula in column C:
=IF(B1<=TODAY(),"YEAR(B1)+1,MONTH(A1),DAY(A1)","YEAR(B1),MONTH(A1),DAY(A1)")

The problem is that the result in C is showing:
YEAR(B1)+1,MONTH(A1),DAY(A1), or the other if the date is after today.
instead of the actual date, which is what I need. mm/dd/yyyy

Is there something I'm leaving out?

This is driving me nuts!
Please, Please, Please, Please, Thank you, Thank you, Thank you, Thank you

 

[Max]

Is there something I'm leaving out?
On the face of it, believe it's the DATE function ..

Try it as:
=IF(B1<=TODAY(),DATE(YEAR(B1)+1,MONTH(A1),DAY(A1)),
DATE(YEAR(B1),MONTH(A1),DAY(A1)))

 

[boschuster50]

Thank you so much! That did it. You are a genius!
This has been driving me nuts for a couple of days now.
Thank you again.

 

[Max]

Welcome. Do click the "Yes" button below, won't you? Greatly enhances thread
longevity.