LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default dates on forms

I am using excel to fill in and print delivery receipts for merchandise.
On one of the forms instead on one block for the date, there are three
seperate
ones for "Month", "Day", and "Year"
I am using the WORKDAY function as the merchandise usually is delivered the
day
after the form is printed.
Is there a way I can get Excel to display ONLY the Month, Day, and Year each
in it's own cell??
Changing the form is not an option as they are specified, and provided by
the vendor through whom the merchandise
is being billed.

Any help will be greatly appreciated.


 
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
Forms Karen D Excel Discussion (Misc queries) 0 January 22nd 10 08:50 PM
Dates in forms Leanne M (Aussie) Excel Discussion (Misc queries) 7 April 30th 08 09:31 AM
Forms Mike Excel Worksheet Functions 0 July 5th 05 11:40 PM
forms Steve Ketchum Excel Programming 0 October 8th 03 05:28 PM
VB Forms Danny Sowden Excel Programming 2 August 19th 03 02:39 PM


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

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

About Us

"It's about Microsoft Excel"