Date finding help

[CameronKuc]

Hello, Im currently working on a spreadsheet for my work to show what parts we need each week to finish our project, i have been requested to make out all the parts by sundays, and was wondering if putting the delivery date in one cell, if there was a formula that would see say "25-Jan" and put "Sunday 28th Jan" or simular in the other cell, thanks

 

[footoo]

To return the next Sunday from a date in A2 : =A2+7-MOD(A2-1,7)
Format the formula cell in the format of your choice.

 

[CameronKuc]

Thanks Mate, Works perfectly, except when a delivery is on a sunday it comes with the following week, is there anyway to make it the current date in the formula if its already on a sunday?

 

[footoo]

=if(weekday(a2)=1,a2,a2+7-mod(a2-1,7))

 

[CameronKuc]

Thanks Mate, works an absolute charm