Date Increment [If A Sunday]

[Bob Beard]

Hi,

Cell B3 is formatted as date [ddd dd mmm yy] and I select
a date from a dropdown in B3 [set up thru Data Validation]

I want cell B5 to equal B3 unless B3 is showing a Sunday,
then I want B5 to increment to the Monday after the
Sunday chosen [if B3 = Sunday then B3 +1 ,if you know
what I mean]

I've tried MATCH function [against a list of all the
Sundays in the year] and IF statemnts but I'm going round
in circles!!

Any help greatly appreciated,

Thanks,

Bob.

 

[JMay]

In Cell B5 (formatted as date) enter:

=IF(WEEKDAY(B3)=1,B3+1,B3)

HTH

 

[Andy B]

Bob

Format B5 as a date and put in it::
=IF(WEEKDAY(B3)=1,B3+1,B3)

Andy