Concept:The
=TODAY() function returns the current date stored by the spreadsheet.
Subtracting
1 from it gives the date of the previous day.
Explanation:The date
02/02/2008 is taken as 2 February 2008 in the day/month/year order.
Spreadsheet programs store dates as serial numbers, so the expression
=TODAY()−1 means one calendar day before the current date.
One day before 2 February 2008 is 1 February 2008.
No change of month or year is needed because subtracting one day does not carry the date into the previous month.
When displayed in
DD/MM/YYYY format, 1 February 2008 is written as
01/02/2008.
Answer:C.
01/02/2008