LinkBack URL
About LinkBacks
See the attachment.
See the attachment.
Hi Spooner,
Is this the formula you asked for?Place this formula in cell I53 and copy it across columns J to M.Formula:
Please Login or Register to view this content.
Note: The EFFECTIVE DATE needs to be placed in cell C59.
Last edited by Saarang84; 05-19-2014 at 08:06 AM.
If my assistance has helped, there is a reputation icon * on the left hand corner below the post - you can show your appreciation to the user who has helped in resolving your requirement.
If your requirement has been solved please mark your thread as Solved.
In the menu bar above the very first post, select Thread Tools, then select "Mark this thread as Solved".
Kindly use [FORMULA] or [CODE] tags when posting your code.
Regards,
Sarang
Saarang84, YOU ARE THE MAN! Thank you for the help it was greatly appreciated......and extremely timely! You have no clue how much this helped!!!!!! AGAIN THANKS BUNCHES!
Hi Spooner,
desktop.xlsx
Assumption
1) Considering the date is entered in A59
2) Date format in I49 to M49 has been modified
Incase u are entering the date in A59 my solution will be good, if date entered in D59 Sarang solution will be good
Regards,
Punnam
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks