LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default dates from a data validation

I need to set up dates to automatically populate from a data validation drop
down box for a time sheet that I am making for work.

The data validation box is F25 and the boxes that I need to auto populate
when each one is selected for the pay periods are boxes C29-I29 and K29-Q29,
which is monday through friday for each pay period over 2 7 day weeks.

Does anyone know how I can do this relatively easily?
 
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
Data Validation for dates ArcticWolf Excel Worksheet Functions 5 March 2nd 09 11:35 AM
Data Validation -- Dates pdberger Excel Worksheet Functions 4 November 30th 07 04:31 AM
Data Validation using Dates caldog Excel Worksheet Functions 8 September 7th 07 01:48 AM
Data validation - dates Slot Excel Discussion (Misc queries) 1 September 6th 07 08:40 AM
Validation using dates... w/o actual dates thinartweakens Excel Discussion (Misc queries) 4 August 2nd 06 03:00 AM


All times are GMT +1. The time now is 08:11 PM.

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

About Us

"It's about Microsoft Excel"