Hi Everyone,
I’m having difficulties writing an IF formula that will shows the word “Weekend” and if the date in cell falls on a weekend and vice versa for the Weekday.
Hi Everyone,
I’m having difficulties writing an IF formula that will shows the word “Weekend” and if the date in cell falls on a weekend and vice versa for the Weekday.
Enter date in A1 and ust this formula
=IF(OR(WEEKDAY(A1)={1,7}),"Weekend","Weekday")
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Thank You so much
Try this for a date in A1
Is that something you can work with?A2: ="Week"&IF(WEEKDAY(A1,2)>5,"end","day")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks