LinkBack URL
About LinkBacks
I need a formula that returns the value based on if it is a weekday or weekend
Date Value Weekday Weekend
Mon 21
Tue 30
Wed 58
Thur 14
Fri 8
Sat 47
Sun 22
Thank you
I need a formula that returns the value based on if it is a weekday or weekend
Date Value Weekday Weekend
Mon 21
Tue 30
Wed 58
Thur 14
Fri 8
Sat 47
Sun 22
Thank you
Hi
'It' being what exactly? A date cell, a text string, today's date???
A workbook would be useful so please upload one. It is always easier to advise if we can see your request in its context.
Show a before and after situation with manually calculated results, explaining which information is data and which is results, and if it's not blindingly obvious how you have arrived at your results some explanatory notes as well. or instance is there some rule that connects the numbers you show to the days of the week or are they just arbitrary?
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Maybe something like this?
Date Value Weekday Weekend Mon Tue Wed Thur Fri Sat Sun
C2=IF(D2="",B2,"")
D2=IF(OR(A2="sat",A2="sun"),B2,"")
both copied down as needed
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Thank you guys
Happy to help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks