Verifying Dates

G

gilbert

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 B
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 (fo
certain criteria), but to show in cell B1 only the year result....ho
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 yea
as in cell A1
if A1's date is smaller than 30/6, then B1 should return with th
preceeding year of cell A1.

Looking forward for your advise and assistance.

Thank you...


Best regards,
Gilber
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Show value from one cell in another cell if today falls between a date range 5
Help with IF Function for times. 5
find out specific month and year 1
Help with an if then scenario 2
Different Functions in One Cell Cancel Each Other Out - How can I fix this? 1
Baffeling IF statement 7
IF AND Function Date Range Issues 6
Time date stamp 0

Top