Previous Topic Next Topic

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.
Related:

2 responses

Answer 1 / 2
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Jan 19, 2015 at 05:45 AM
in B1 the formula is

=TODAY()+A1*7
5
Answer 2 / 2
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

Similar discussions

Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses