Calculate a date from a given date

**AppSupportKarl** · 01-06-2012, 04:39 AM

Hello every one!

i need to check a date with another, using the below logic:

if product = A then Date D = 6 months after Date C
If Product = B then date D = 1 month after Date C

Date C is predifined with each file, and is in the following format "yyyymmdd"

To put this into context, Date C is the date account opened, and Date D is the Next Statement Date. both dates will be present in the file, but i need to check that Date D is correct based off the product type and Date C

**Fotis1991** · 01-06-2012, 04:59 AM

Hi

Pls try this:

=IF(A1="a";DATE(YEAR(C1);MONTH(C1)+6;DAY(C1));IF(A1="b";DATE(YEAR(C1);MONTH(C1)+12;DAY(C1))))

Hope to helps you.

**Firefly2012** · 01-06-2012, 05:02 AM

You could just use EDATE to shift Date C by the given number of months. EDATE requires the Analysis Toolpak to be installed in versions earlier than 2007, but I see you are using 2007. EDATE is a worksheet function.

**AppSupportKarl** · 01-06-2012, 05:59 AM

Many thanks firefly, this is perfect for what i need!

Fotis,

thanks for your suggestion, i was going to try something similar, but for end of month days (e.g. feb 28th) i wasn't sure if it would work or not