View original (French)

Excel formula to determine a follow-up date

Solved
lp -  
 lp -
Hello,

I would like to have a follow-up date in one column 15 days after the sending date.
What formula should I use, please?

Thanks in advance

Configuration: Windows 7 / Mozilla 11.0

2 answers

  1.
    PHILOU10120 Posted messages 6463 Registration date   Status Contributor Last intervention   835
     
    Hello

    Your date in column B in column C

    =B2+15

    or this one

    =DATE(year(B2);month(b2);day(b2)+15)

    --
    It's by forging that one becomes a blacksmith. - It's at the foot of the wall that one sees the mason - one always learns from their mistakes
    2