Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
working with dates in excel
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))) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "boschuster50" wrote: 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
working with dates in excel
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" wrote: 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))) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "boschuster50" wrote: 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
working with dates in excel
Welcome. Do click the "Yes" button below, won't you? Greatly enhances thread
longevity. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "boschuster50" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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) |