Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Verifying Dates
Dear Excel Experts, Could anyone please show me how should I overcome this problem:- 1) Supposing I have a cell, say cell A1 with the formula "=today()" - this will show today's date in cell A1 2) I need cell B1 to check cell A1 to determine the result. Cell B1 will be using a simple formula of "if....then...else". If I want cell B1 to check only the day and month of cell A1 (for certain criteria), but to show in cell B1 only the year result....how should I approach this? The criteria for cell B1 would be if A1's date is larger than 30/6, then B1 should return with the year as in cell A1 if A1's date is smaller than 30/6, then B1 should return with the preceeding year of cell A1. Looking forward for your advise and assistance. Thank you... Best regards, Gilbert -- gilbert An eager learner for Excel ------------------------------------------------------------------------ gilbert's Profile: http://www.excelforum.com/member.php...fo&userid=4686 View this thread: http://www.excelforum.com/showthread...hreadid=465782 |
#2
|
|||
|
|||
Try =IF(MONTH(A1)6,YEAR(A1),YEAR(A1)-1)
Regards Rowan gilbert wrote: Dear Excel Experts, Could anyone please show me how should I overcome this problem:- 1) Supposing I have a cell, say cell A1 with the formula "=today()" - this will show today's date in cell A1 2) I need cell B1 to check cell A1 to determine the result. Cell B1 will be using a simple formula of "if....then...else". If I want cell B1 to check only the day and month of cell A1 (for certain criteria), but to show in cell B1 only the year result....how should I approach this? The criteria for cell B1 would be if A1's date is larger than 30/6, then B1 should return with the year as in cell A1 if A1's date is smaller than 30/6, then B1 should return with the preceeding year of cell A1. Looking forward for your advise and assistance. Thank you... Best regards, Gilbert |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2 digit year in dates return 19xx not 20xx | Excel Discussion (Misc queries) | |||
Default Dates | Excel Discussion (Misc queries) | |||
Using dates for x-axis values as string instead of creating a scale | Charts and Charting in Excel | |||
Formating Dates for production schedule | Excel Discussion (Misc queries) | |||
due dates | New Users to Excel |