Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Working with dates in excel | Excel Worksheet Functions | |||
working with dates | Excel Worksheet Functions | |||
Working with Dates | Excel Discussion (Misc queries) | |||
Text to Columns not working correctly with dates in Excel 2007 | Excel Discussion (Misc queries) | |||
Working with dates | Excel Discussion (Misc queries) |