Register
Log In
Unanswered
Home
December 25, 2016
Offline
In column A, I manually enter the date of submitting photos to an organisation.
Column B automatically enters the month of this date - in text
What I would like to automatically happen in column C:
Look at the date in column A and then enter the date of the next Monday after this column A date
I have added a sample file to show what I mean ... Hmmm can't seem to add an .xlxs file attachment - so see screenshot above
Thank you very much for any assistance
See Answer
Dashboards
June 25, 2016
Offline
Hi Ace
Try this in cell C2
=A2+8-WEEKDAY(A2,2)
Sunny
Answers Post
Most Users Ever Online: 57
Currently Online: Mynda Treacy
13 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 651
Frans Visser: 210
David_Ng: 96
mey tithveasna: 71
A.Maurizio: 60
rathanak: 58
yhooithin05: 54
Anders Sehlstedt: 47
julian: 46
PaulFogel: 37
Newest Members:
Md. Rahman
Lilian Vo
Jane Kumwenda
David Miller
Efe Onwochei
LynAnn Williams
Brandy Kriger
purna chandar
E K
velissa barr
Forum Stats:
Groups: 2
Forums: 18
Topics: 935
Posts: 4405
Member Stats:
Guest Posters: 1
Members: 42350
Moderators: 1
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas
