View Single Post
  #2   Report Post  
Old January 19th 16, 04:07 PM posted to microsoft.public.excel.worksheet.functions
Claus Busch Claus Busch is offline
external usenet poster
First recorded activity by ExcelBanter: Apr 2011
Posts: 3,872
Default How do I "not" enter slashes for dates and add "x" number of days to date entered?


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))

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