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
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.
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:
- IF function with DATE in Excel
- How to change date format in excel - Guide
- Gif in excel - Guide
- Number to words in excel - Guide
- Excel mod apk for pc - Download - Spreadsheets
- Marksheet in excel - Guide
2 responses
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Jan 19, 2015 at 05:45 AM
Jan 19, 2015 at 05:45 AM
in B1 the formula is
=TODAY()+A1*7
=TODAY()+A1*7
ace-82
Posts
2
Registration date
Monday January 19, 2015
Status
Member
Last seen
January 19, 2015
Jan 19, 2015 at 05:49 AM
Jan 19, 2015 at 05:49 AM
Perfect!!! Thank you so much!!!!