How can I create a formula in Google Spreadsheets that makes use of a day layout

How do I subtract days from a cell that has days?

As an example, what is a formula that will take 3/ 2/2011 and also return this value 2/ 28/2011?

Is this feasible in Google Spreadsheets?

2019-12-02 02:56:58
Source Share
Answers: 1

You can do it comparable to Excel. Merely subtract the variety of days from the cell.

As an example : If you have in cell A1 3/ 2/2011 you can get 2/ 28/2011 in a cell by getting in the formula =A1-3

2019-12-03 04:34:31