working with dates in excel

  • Thread starter Thread starter boschuster50
  • Start date Start date
B

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
 
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)))
 
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.
 
Back
Top