have number of columns with different dates, where one of the column has date range (03/02/2015-01/08/2015), rest columns like (17/07/2016). Need to calculate remaining month or days, if month not possible, to the closest one date in a line from current date. In column which shown as range must be taken to calculation last date (01/08/2015)!
Last edited by SevcovPa; 04-13-2015 at 08:46 AM.
If possible, please attache sample work book.. i am leaving from office..i did some changes see if its work for you..will upload final file tomorrow.
Regards,
Suhas
Pls see attached. Row G is a target for which I need proper formula.
So nobody can help with formula?
Solved (see attached)Next due surveys.xlsx
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks