Hi, I need help in these two functions which I want to compute it into a formula for my data.
Cell L Cell M Cell N
First Day Last Day Comments
02/09/2016 07/09/2016 Dealers Please Take Note
07/09/2016 Liquidate
09/09/2016 To liquidate or waiting for approval
I want to do a IF WORKDAY or VBA codes to compute the workday of Last day/First day
-First day on Cell "L"
-Last day on Cell "M"
-Comments on Cell "N"
Dates on "First day" cell are the first priority.
Note that some of my data doesn't have dates on "First Day", if that so, take the dates on "Last Day"
I want to have an IF function that if it is:
-1 to 2 days from the today(eg. 07/09/2016), I want to have a "To liquidate" comment on cell N
-3 to 4 days, "To liquidate or waiting for approval"
-5 to 7 days, "Dealers please take note"
As it will have a large data, I would like it to be autofill down cell "N"
I am sure that a simple IF and WORKDAY function is not enough for these to work so I think a VBA code should work.
Hope the pros and gurus here are able to help me. Thanks in advance!
PS. The dates are in dd/mm/yy format.
Cell L Cell M Cell N
First Day Last Day Comments
02/09/2016 07/09/2016 Dealers Please Take Note
07/09/2016 Liquidate
09/09/2016 To liquidate or waiting for approval
I want to do a IF WORKDAY or VBA codes to compute the workday of Last day/First day
-First day on Cell "L"
-Last day on Cell "M"
-Comments on Cell "N"
Dates on "First day" cell are the first priority.
Note that some of my data doesn't have dates on "First Day", if that so, take the dates on "Last Day"
I want to have an IF function that if it is:
-1 to 2 days from the today(eg. 07/09/2016), I want to have a "To liquidate" comment on cell N
-3 to 4 days, "To liquidate or waiting for approval"
-5 to 7 days, "Dealers please take note"
As it will have a large data, I would like it to be autofill down cell "N"
I am sure that a simple IF and WORKDAY function is not enough for these to work so I think a VBA code should work.
Hope the pros and gurus here are able to help me. Thanks in advance!
PS. The dates are in dd/mm/yy format.
Last edited: