Add weeks to a date
Solved
UsulArrakis
Posted messages
7683
Status
Contributeur
-
UsulArrakis Posted messages 7683 Status Contributeur -
UsulArrakis Posted messages 7683 Status Contributeur -
Hello,
Excel 2010
I would like to add 6 weeks to a date to obtain the new date.
The YEAR, MONTH, or DAY functions exist in Excel but not WEEK
Does anyone have an idea, preferably with a formula, or otherwise with a macro?
Thank you
Configuration: Win XP pro
(_Usul d'Arrakis
Serial_Dreamer_)
Excel 2010
I would like to add 6 weeks to a date to obtain the new date.
The YEAR, MONTH, or DAY functions exist in Excel but not WEEK
Does anyone have an idea, preferably with a formula, or otherwise with a macro?
Thank you
Configuration: Win XP pro
(_Usul d'Arrakis
Serial_Dreamer_)
3 réponses
Hello,
Your date in A1, the number of weeks in B1
=A1+(B1*7)
Wednesday 12/6/13 in A1 gives Wednesday 27/7/13
Best regards
--
Michel
Your date in A1, the number of weeks in B1
=A1+(B1*7)
Wednesday 12/6/13 in A1 gives Wednesday 27/7/13
Best regards
--
Michel
Hi,
this amounts to adding days,
1 week = 7 days
6 weeks x 7 days = 42 days
so date + 42
or more technically
=DATE(YEAR(A1);MONTH(A1);DAY(A1)+42)
except that you haven't mentioned everything and taking into account business days and public holidays
--
See you +
Mike-31
A period of failure is a perfect time to plant the seeds of knowledge.
this amounts to adding days,
1 week = 7 days
6 weeks x 7 days = 42 days
so date + 42
or more technically
=DATE(YEAR(A1);MONTH(A1);DAY(A1)+42)
except that you haven't mentioned everything and taking into account business days and public holidays
--
See you +
Mike-31
A period of failure is a perfect time to plant the seeds of knowledge.
Either I'm an idiot or you can tell it's Friday and I'm tired from my work week! :-DDD
Actually, I just needed D2*7, how foolish of me!!!
A big thank you to both of you
I'm mixing your solutions in my file:
=DATE(YEAR(A2)+B2;MONTH(A2)+C2;DAY(A2)+E2+(D2*7))
and
=DATE(YEAR(A2)-B2;MONTH(A2)-C2;DAY(A2)-E2-(D2*7))
--
(_Usul from Arrakis
Serial_Dreamer_)
Actually, I just needed D2*7, how foolish of me!!!
A big thank you to both of you
I'm mixing your solutions in my file:
=DATE(YEAR(A2)+B2;MONTH(A2)+C2;DAY(A2)+E2+(D2*7))
and
=DATE(YEAR(A2)-B2;MONTH(A2)-C2;DAY(A2)-E2-(D2*7))
--
(_Usul from Arrakis
Serial_Dreamer_)