Is there a function that can work out from a date (in format dd/mm/yy)
whether the date falls on a weekend day i.e. a saturday or sunday?

Thanks

John

Hi,
Look into CPearson web it has everything related to dates

http://www.cpearson.com/excel/datetime.htm#AddingDates

if this helps please click yes, thanks

"JRD" wrote:

Is there a function that can work out from a date (in format dd/mm/yy)
whether the date falls on a weekend day i.e. a saturday or sunday?

Thanks

John

=TEXT(A1,"dddd")


"JRD" wrote:

Is there a function that can work out from a date (in format dd/mm/yy)
whether the date falls on a weekend day i.e. a saturday or sunday?

Thanks

John

Try the function which returns TRUE if the date in A1 is a weekend..

=MOD(A1,7)<2

If this post helps click Yes
---------------
Jacob Skaria


"Teethless mama" wrote:

=TEXT(A1,"dddd")


"JRD" wrote:

Is there a function that can work out from a date (in format dd/mm/yy)
whether the date falls on a weekend day i.e. a saturday or sunday?

Thanks

John

Hi,

This returns TRUE for a weekday or FALSE for a weekend

=IF(ISERROR(VLOOKUP(WEEKDAY(A2),{2;3;4;5;6},1,0)), FALSE,TRUE)

Mike

"JRD" wrote:

Is there a function that can work out from a date (in format dd/mm/yy)
whether the date falls on a weekend day i.e. a saturday or sunday?

Thanks

John

That's not true if you're using the 1904 base date.

=WEEKDAY(A1,2)5

Should work for either base date.

Jacob Skaria wrote:

Try the function which returns TRUE if the date in A1 is a weekend..

=MOD(A1,7)<2

If this post helps click Yes
---------------
Jacob Skaria

"Teethless mama" wrote:

=TEXT(A1,"dddd")


"JRD" wrote:

Is there a function that can work out from a date (in format dd/mm/yy)
whether the date falls on a weekend day i.e. a saturday or sunday?

Thanks

John

--

Dave Peterson

Hi,

This may not be enough for your needs but change the cell format to
ddd - mm/dd/yy

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"JRD" wrote:

Is there a function that can work out from a date (in format dd/mm/yy)
whether the date falls on a weekend day i.e. a saturday or sunday?

Thanks

John