writer
6,694
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: + − + − + + + − + − + − +
no edit summary
=WEEKDAY(SN, Type)=
=WEEKDAY(SN, Type)=
<div style="font-size:30px">'''WEEKDAY (Value,Type)'''</div><br/>
where,
where,
*<math>SN</math> represents a date for which day has to be displayed,
*<math>Value</math> represents a date for which day has to be displayed.
*<math>Type</math> represents the type of return value.
*<math>Type</math> represents the type of return value.
WEEKDAY() displays a number that indicates the day of the week corresponding to a date.
WEEKDAY(), converts a number to a day of the week.
a serial number to a day of the week.
== Description ==
== Description ==
WEEKDAY(SN, Type)
WEEKDAY(Value,Type)
*<math>SN</math> is a date value to be entered either in 'date format' or 'dates returned using formulas'.
*<math>Value</math> is a date value to be entered either in 'date format' or 'dates returned using formulas'.
*If <math>SN</math> values are invalid, Calci displays #N/A error message.
*If <math>Value</math> values are invalid, Calci displays #N/A error message.
*We can use the DD/MM/YYYY format also. For Example:"14/5/2005[DD/MM/YYYY]".
*We can use the DD/MM/YYYY format also. For Example:"14/5/2005[DD/MM/YYYY]".
*<math>Type</math> is the type of return value. It can be from the following -
*<math>Type</math> is the type of return value. It can be from the following -