IF function with DATE in Excel

Solved/Closed
ace-82
Posts
2
Registration date
Monday January 19, 2015
Status
Member
Last seen
January 19, 2015
- Jan 19, 2015 at 04:20 AM
ace-82
Posts
2
Registration date
Monday January 19, 2015
Status
Member
Last seen
January 19, 2015
- Jan 19, 2015 at 05:49 AM
Hi, hope someone can assit. I need to create a sheet where I must take the current date and add a fulle week or two weeks to the date by selecting an opton 1 or 2.

For example, if the current date is 19/01/2015 and I add a one in A1 then B1 must show 26/01/2015 and if I enter a two in A1 the value in A1 must become 02/02/2015

Hope this makes sense?

Thanks in advance.

2 replies

venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
805
Jan 19, 2015 at 05:45 AM
in B1 the formula is

=TODAY()+A1*7
5
ace-82
Posts
2
Registration date
Monday January 19, 2015
Status
Member
Last seen
January 19, 2015

Jan 19, 2015 at 05:49 AM
Perfect!!! Thank you so much!!!!
0