Im look to identify Friday between to dates. Example: start date 12/23/2014 end date 12/30/14 find 12/26/2014 which is a Friday. Or start 1/10/2015 end date 1/17/2015 find 1/16/2015.
Identify a specific day between two dates
March 16th, 2015 7:16pm
Let's say you have the start date in cell A1. In another cell, enter the formula
=A1+MOD(6-A1,7)
Format the cell with the formula as a date. It will return the first Friday on or after the start date.
If you have Excel 2010 or later, you can also use
=A1+7-WEEKDAY(A1,16)
Either formula can be filled down.
Free Windows Admin Tool Kit Click here and download it now
March 17th, 2015 1:37am
Thank you.
March 25th, 2015 5:18pm
This topic is archived. No further replies will be accepted.
Other recent topics
