hi everyone, how can i get dates ending friday's for last month
for example

Range("C1")=Jan 1
Range("D1")=Jan 8
Range("E1")=Jan 15
Range("F1")=Jan 22
Range("G1")=Jan 29

using formula below but its only for current month. need some assistance...Thanks!!
=TODAY()+(6-WEEKDAY(TODAY(),1))