Find previous Saturday and next friday dates given a date

Hi,

I have a situation where i have a work week from Satuday to Friday.

I have a date...........say UserDate.

Example1 of what i want:
UserDate = 5/2/16
SatDate = 4/30/16
FriDate = 5/6/16

Example2 of what i want:
UserDate = 4/30/16
SatDate = 4/30/16
FriDate = 5/6/16

Example3 of what i want:
UserDate = 5/14/16
SatDate = 5/9/16
FriDate = 5/15/16

How to calculate the SatDate and FriDate?

I am soooooo sorry........the calendar apparently switched on me..........

lets try this again:

Example3 of what i want:
UserDate = 5/12/16
SatDate = 5/7/16
FriDate = 5/13/16

thanks! i think your soln does work. again, so sorry about the mistake on the date. thanks!

hi i tried the formula you suggested in my vba code and when i try to run it the "16" is causing it to stop. It does not like the 16.

also, the formula does not appear to work at the "ends" of the week. for example, recall that my week runs Saturday to Friday.

If i pick a day say saturday 5/7/16 then i would want the date returned to be 5/7/16 since this is on a saturday........but the formula returns 4/30/16


any ideas?

ok i got the 16 to work.......i used this

Please Login or Register  to view this content.

This formula does actually work. my only concern now is that the formula will only work if
the person has excel 2010. I am not sure if this will be true in all cases...........

is there a way to do this without using functions only applicable to 2010?

Hi,

So there are two dates to determine: Start-date and End-date.

If user date is 5/6/16 = A friday.........and this is in the start section.......then the adjusted start date is the earliest Saturday
prior to 5/6/16 which is 4/30/16.

Similarly, if user date is 5/6/16= a friday.......and this is in the end section.......then the adjusted date is the latest/closest friday
to the given date which is the day itself.......so end date is 5/6/16

does this make sense?

nice.......i think this works......i will continue checking to be sure and let you know but i dont know why but i was looking for some
elegant math formula.......i like your approach......just use an if statement to figure out the edges....thanks.