Date and If function [Closed]

Report
-
Posts
122
Registration date
Tuesday August 31, 2010
Status
Contributor
Last seen
June 20, 2016
-
Hello,

Thank you for your time!

I want excel to determine the date on multiple conditions.
If the given date in A1 is 29-Nov-1980 and one of the conditions is 30-Jun-2016 then the date should result to 29-Nov-2014. Please refer to the table below for more conditions.

Date of joining As of this year Condition 1

27-Jun-05 27-Jun-15 30-Sep-15
02-Jul-05 02-Jul-15 30-Sep-15

10-Sep-05 10-Sep-13 30-Sep-15
01-Dec-05 01-Dec-13 30-Sep-15

15-Jul-06 15-Jul-14 30-Sep-15
07-Aug-06 07-Aug-14 30-Sep-15

The table above is the actual solution that I am looking for. I have huge data and have to process every month. The second condition deals with Odd and Even years.

Please help me in this if possible.

Many thanks in advance!

best regards,

Arun




1 reply

Posts
122
Registration date
Tuesday August 31, 2010
Status
Contributor
Last seen
June 20, 2016
24
What are the conditions?

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!