Hi all,

Thanks in advance for any help you can provide.

The problem: Currently I have a date in Cell "A1" and would like to add a certain number of days to it and return a value in the following format "Q1-17"

Note: Dates are in French format.

Example: Cell A1 contains 01/12/16 (so: 1st of December 2016)
I need this date plus 6 weeks or 42 days (equals 12/1/17 or the 12th of Jan. 2017)
Cell B1 should read Q1-17

I currently have a formula shown below:
=IF([@METIER]="MF";"Q"&INT((MONTH([@ORDER]+42)-1)/3)+1&"-"&RIGHT(YEAR([@ORDER]);2);"-")

However this will only work for if the date in cell A1 + X amount of days is a date before the 1st of December for the same year.

Any suggestions?