LinkBack URL
About LinkBacks
i want to make formula for these two problem , conditional formatting and workday function . Please help me if you can solve it
i want to make formula for these two problem , conditional formatting and workday function . Please help me if you can solve it
hi okyjelly, welcome to the forum. you can use WORKDAY in D3 like mentioned in your title:
=WORKDAY(A3,C3)
for conditional formatting, select the range you want to apply to (i.e. A3:D12)
go to Home -> Conditional Formatting -> New Rule -> Use a formula to determine which cells to format -> Format values where this formula is true:
=$D3=TODAY()
Last edited by benishiryo; 02-13-2013 at 09:34 PM. Reason: amendment
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
Thankyou verymuch :D
hai benishiryo, thanks for helping me to solve my problem
but i want to ask you, if i use this formula
=WORKDAY(A3,C3), the "day of analysis" will be count just in monday until friday .
but i need a result like this :
Sample Delivery Days of Analysis Release
Friday, February 15, 2013 1 Monday, February 18, 2013
Friday, February 15, 2013 5 Wednesday, February 20, 2013
Try this version
=WORKDAY(A3+C3-1,1)
Audere est facere
thankyou daddylonglegs
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks