Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 19th 16, 03:46 PM
Junior Member
 
First recorded activity by ExcelBanter: Mar 2012
Posts: 4
Default 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

  #2   Report Post  
Old January 19th 16, 04:07 PM posted to microsoft.public.excel.worksheet.functions
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?

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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell Steve Kay Excel Discussion (Misc queries) 2 August 8th 08 01:54 AM
change "true" and "false" to "availble" and "out of stock" inthestands Excel Worksheet Functions 2 July 19th 07 07:05 PM
Help!!! Enter "7" in a cell and Excel changes the "7" to "11" immediately!!! [email protected] Excel Discussion (Misc queries) 3 January 5th 07 02:18 PM
HELP on "left","right","find","len","substitute" functions serene83 Excel Discussion (Misc queries) 5 June 27th 06 02:23 AM
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next BCB New Users to Excel 7 May 13th 06 10:02 PM


All times are GMT +1. The time now is 05:14 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017