I need to write a formula that will take a date like 11/10/14, add 30 days and give me the date of the next Tuesday.
I'm guessing a Date/If statement combo??? Or maybe the traditional "look at a calendar" method. Any help is appreciated
I need to write a formula that will take a date like 11/10/14, add 30 days and give me the date of the next Tuesday.
I'm guessing a Date/If statement combo??? Or maybe the traditional "look at a calendar" method. Any help is appreciated
assuming A1 is your date
Formula:Please Login or Register to view this content.
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks