View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
boschuster50 boschuster50 is offline
external usenet poster
 
Posts: 9
Default working with dates in excel

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)","YE AR(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