Is there a code or formula that would convert a weekend date to the previous friday at 11:59pm? For example: in cell A1 I have "5/23/15 8:37", which is a saturday. How could I have that number transformed into "5/22/15 23:59", which is the friday prior to that saturday? I have several other dates in my list that do not end on the weekend and those need to stay the same. Any help would be greatly appreciated.
Hello,
Here's a suggestion:
Please Login or Register to view this content.
Last edited by GC Excel; 05-27-2015 at 04:56 PM. Reason: correct formula
GC Excel
If this post helps, then click the star icon (*) in the bottom left-hand corner of my post to Add reputation.
Try this formula
=IF(WEEKDAY(A1,2)>5,WORKDAY(A1,-1)+"23:59",A1)
Audere est facere
Are all the dates is the same column?
Do you want to replace the date or use an extra column with the new date value
- Battle without fear gives no glory - Just try
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks