Dates

[Anthony]

In column A the date is entered
In column B the date is copied and formatted as dddd ie full name of day of
week.
I wish to create a formula: if(B2 = "Saturday", etc etc) Unfortunately it
will not work because the entry in column B is not text. Is there any way I
can get the formula to recognise days of the week?

 

[Frank Kabel]

Hi
try
=IF(WEEKDAY(B2)=7,....)

 

[William]

Hi Anthony

With Sunday being equal to 1, Monday being equal to 2 and so on........
=IF(WEEKDAY(B2)=5, "Its Thursday", "Its not Thursday")

You don't actually need column B for this as Column A would also return the
same result.
=IF(WEEKDAY(A2)=5, "Its Thursday", "Its not Thursday")

--
XL2002
Regards

William

(e-mail address removed)

| In column A the date is entered
| In column B the date is copied and formatted as dddd ie full name of day
of
| week.
| I wish to create a formula: if(B2 = "Saturday", etc etc) Unfortunately it
| will not work because the entry in column B is not text. Is there any way
I
| can get the formula to recognise days of the week?

 

[Anthony]

Thank you Frank. That worked fine.

Hi
try
=IF(WEEKDAY(B2)=7,....)