Weekends

[JRD]

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

 

[Eduardo]

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

 

[Teethless mama]

=TEXT(A1,"dddd")

 

[Jacob Skaria]

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

=MOD(A1,7)<2

If this post helps click Yes

 

[Mike H]

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

 

[Dave Peterson]

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

=WEEKDAY(A1,2)>5

Should work for either base date.

 

[Shane Devenshire]

Hi,

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