Question

Ian needs to extract the day from the date 5/31/2017 entered in cell A1. Which formula can he use to do this

Answer 1

A cell is a box which can be seen in an Excel sheet. Ian needs to write the formula "=day(A1)".

What is Cell in an Excel?

A cell is a box which can be seen in an Excel sheet, this box is named A1, B2, etc. The name of a cell depends upon the column and the row in which it is present.

In case, if Ian needs to extract the day from the date from cell A1. He needs to write the formula:

=day(A1)

This will give the output as 31.

In case, if Ian needs to extract the weekday from the date in cell A1. He needs to write the formula,

=weekday(A1,1)

This will return a number between 1 to 7 which will represent Sunday to Saturday respectively.

Learn more about Excel:

https://brainly.com/question/3441128

#SPJ1