Logical or
If the entered date is either Saturday or sunday, then calculatio
should take place. =IF(OR(WEEKDAY(J6)=1,7),"True","False") Is the above formula is correct -- Message posted from http://www.ExcelForum.com |
Logical or
Hi
try =IF(OR(WEEKDAY(J6)=1,WEEKDAY(J6)=7),"True","False" ) Frank If the entered date is either Saturday or sunday, then calculation should take place. =IF(OR(WEEKDAY(J6)=1,7),"True","False") Is the above formula is correct? --- Message posted from http://www.ExcelForum.com/ |
Logical or
|
Logical or
The formula should be
=IF(AND(J6<0,OR(WEEKDAY(J6)=1,WEEKDAY(J6)=7)),TRU E,FALSE ----- Supriya wrote: ---- If the entered date is either Saturday or sunday, then calculatio should take place =IF(OR(WEEKDAY(J6)=1,7),"True","False" Is the above formula is correct -- Message posted from http://www.ExcelForum.com |
Logical or
No. Try this:
=IF(OR(WEEKDAY(J6)=1,WEEKDAY(J6)=7),"True","False" ) HTH, Nikos "Supriya " wrote in message ... If the entered date is either Saturday or sunday, then calculation should take place. =IF(OR(WEEKDAY(J6)=1,7),"True","False") Is the above formula is correct? --- Message posted from http://www.ExcelForum.com/ |
Logical or
Supriya,
If you just want True or False, you can siumply use =OR(WEEKDAY(J6)=1,WEEKDAY(J6)=7) -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Frank Kabel" wrote in message ... Hi try =IF(OR(WEEKDAY(J6)=1,WEEKDAY(J6)=7),"True","False" ) Frank If the entered date is either Saturday or sunday, then calculation should take place. =IF(OR(WEEKDAY(J6)=1,7),"True","False") Is the above formula is correct? --- Message posted from http://www.ExcelForum.com/ |
Logical or
One way:
=WEEKDAY(J6,3)4 or =IF(WEEKDAY(J6,3)4,<do if true,<do if false) In article , Supriya wrote: If the entered date is either Saturday or sunday, then calculation should take place. =IF(OR(WEEKDAY(J6)=1,7),"True","False") Is the above formula is correct? --- Message posted from http://www.ExcelForum.com/ |
Logical or
Try
=IF(WEEKDAY(J6,3)4,"True","False") -- Supriya wrote in message ... If the entered date is either Saturday or sunday, then calculation should take place. =IF(OR(WEEKDAY(J6)=1,7),"True","False") Is the above formula is correct? --- Message posted from http://www.ExcelForum.com/ |
Logical or
|
All times are GMT +1. The time now is 03:36 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com