Question

Each service starts on a different date because the services depend on each other. Enter the starting dates for the remaining services as follows:
a. In cell D6, enter a formula without using a function that adds 4 days to the value in cell 06.
b. In cell E6, enter a formula without using a function that subtracts 3 days from the value in cell C6
c. In cell F6, enter a formula without using a function that adds 2 days to the value in cell E6
d. In cell G6, enter a formula without using a function that adds 2 days to the value in cell C6.

Answer 1

Answer:

a. Copy the range of cell D7:D9 then select cell D6 and paste the selection with date format selected. The function will be represented in formula bar with adding +4;365 days.

b. Copy the range of cell D7:D9 then select cell D6 and paste the selection with date format selected. The function will be represented in formula bar with adding -3;365 days.

c. In the formula bar type =365 days; +2 : E6

d. In the formula bar type =365 days ; +2 : C6

Explanation:

Excel is a software which helps the users to easily calculate complex calculation with just one function input. The users can create worksheets using the excel and then link those worksheets with each other. The data can be displayed in the form of table or simple text. It has multiple options to create annual day wise filtered worksheets.