Hello all.
In my workbook i want to calculate a date with certain periods.
My table look like this:
My problem is:
1. I don't know how to write the formula from column C;
2. In the column C i wanted in the function to do the calculation, but i wanted to calculate that date minus 10 days.
e.g. instead of 11.07.2009 => 01.07.2009.
Could you help me?Please.
Many thanks!
In my workbook i want to calculate a date with certain periods.
My table look like this:
Code:
A B C
Current Date Period between tests Next Period
11.03.2009 (here i have to choose 1;3;6 or 12 months) =(A1+B1)
e.g 11.04.2009
or 11.07.2009,etc
My problem is:
1. I don't know how to write the formula from column C;
2. In the column C i wanted in the function to do the calculation, but i wanted to calculate that date minus 10 days.
e.g. instead of 11.07.2009 => 01.07.2009.
Could you help me?Please.
Many thanks!