ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I "not" enter slashes for dates and add "x" number of days to date entered? (https://www.excelbanter.com/excel-worksheet-functions/451266-how-do-i-not-enter-slashes-dates-add-x-number-days-date-entered.html)

yeto January 19th 16 03:46 PM

How do I "not" enter slashes for dates and add "x" number of days to date entered?
 
I am trying to "not" have to enter slashes when entering a date and I want to add "x" number of days to date entered? I am using formulas from the following article but I can't get some of the process to work.

http://www.pcmag.com/article2/0,2817,2316755,00.asp

Using 00\/00\/0000 is working as expected and doing what I need but when I use =DATE(MOD(A2, 10000), TRUNC(A2 / 1000000), MOD(TRUNC(A2 / 10000), 100)) I am getting the following error message. "There is a problem with a number used in the formula." If I am able to get the second part to work would I then use a formula something like = B1+10 to add 10 days to date entered?

Thank you in advance for any help,
yeto

Claus Busch January 19th 16 04:07 PM

How do I "not" enter slashes for dates and add "x" number of days to date entered?
 
Hi,

Am Tue, 19 Jan 2016 15:46:51 +0000 schrieb yeto:

Using 00\/00\/0000 is working as expected and doing what I need but when
I use =DATE(MOD(A2, 10000), TRUNC(A2 / 1000000), MOD(TRUNC(A2 / 10000),
100)) I am getting the following error message. "There is a problem with
a number used in the formula." If I am able to get the second part to
work would I then use a formula something like = B1+10 to add 10 days to
date entered?


delete the spaces into the formula:
=DATE(MOD(A2,10000), TRUNC(A2/1000000), MOD(TRUNC(A2/10000),100))


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional


All times are GMT +1. The time now is 04:15 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
ExcelBanter.com