Creating a date box

		Microsoft Office Forums > Microsoft Excel > Excel
Creating a date box

FAQ

Mark Forums Read

Thread Tools

Display Modes

05-11-2011, 03:01 AM

Philip290

Windows 7 32bit Creating a date box

Office 2010 32bit

Novice

Join Date: May 2011

Posts: 3

Quote:

Originally Posted by OTPM

Hi Philip209

You can simply add the entry in one cell to the start date:
Example:
In a new column - A3+A2.
Where A3 is the start date of leave in date format and A2 is the number of days the member of staff is taking off.
Hope this helps.
Tony

Hi OTPM, that's fantastic and exactly what I was after.

Thanks!

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Date pop-up window	Roshan Hanief	Word	0	04-23-2011 04:16 AM
Creating an Auto-Calc'd Date? Today+7 Days?	SoCalTelephone	Word	0	10-06-2010 10:27 AM
Julian Date	windseaker	Excel	1	02-14-2010 01:44 AM
new appointment date always reverts back to today's date	msills	Outlook	0	08-24-2007 08:57 AM
Imported message date change to today's date	promark	Outlook	1	12-23-2005 07:21 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:07 PM.