Find Specific date in Biwwekly Based on date
Try this
=IF(MOD(WEEKNUM(A1),2)=1,A1+CHOOSE(WEEKDAY(A1),13, 12,11,10,9,8,7),A1+CHOOSE(WEEKDAY(A1),6,5,4,3,2,1, 0))
Mike
"jlclyde" wrote:
I am trying to find the next biweekly end date based on todays date.
The biweeklies end on Saturdays and that is the date I need to
return. 1-24-09, 1-10-09, 12-27-08. These are some of the dates.
Is there a way to do this with functions in excel or is this going to
have to be a UDF?
Thanks in advance,
Jay
|