IF function with DATE in Excel [Solved/Closed]

Report
Posts
2
Registration date
Monday January 19, 2015
Status
Member
Last seen
January 19, 2015
-
Posts
2
Registration date
Monday January 19, 2015
Status
Member
Last seen
January 19, 2015
-
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

Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
790
in B1 the formula is

=TODAY()+A1*7
5
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 3794 users have said thank you to us this month

Posts
2
Registration date
Monday January 19, 2015
Status
Member
Last seen
January 19, 2015

Perfect!!! Thank you so much!!!!