Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
date
hi, i need help with writing a code that would allow me to input dat between mondays to saturdays monthly excluding sundays. Does anyon know how to go about this please, help needed urgently. Thanks, angel -- angelaegbun ----------------------------------------------------------------------- angelaegbunu's Profile: http://www.excelforum.com/member.php...fo&userid=2663 View this thread: http://www.excelforum.com/showthread.php?threadid=39906 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
date
Hi Angela,
Here is some sample code Dim ans ans = InputBox("Input date") If ans < "" Then If IsDate(ans) Then If ActiveSheet.Evaluate("Weekday(""" & Format(ans, "yyyy/mm/dd") & """,2)") 5 Then MsgBox "weekends not allowed" End If Else MsgBox "dates only" End If End If -- HTH RP (remove nothere from the email address if mailing direct) "angelaegbunu" wrote in message news:angelaegbunu.1ubsah_1124982340.6583@excelforu m-nospam.com... hi, i need help with writing a code that would allow me to input date between mondays to saturdays monthly excluding sundays. Does anyone know how to go about this please, help needed urgently. Thanks, angela -- angelaegbunu ------------------------------------------------------------------------ angelaegbunu's Profile: http://www.excelforum.com/member.php...o&userid=26633 View this thread: http://www.excelforum.com/showthread...hreadid=399069 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
date
Thanks do appreciate ur help:) -- angelaegbunu ------------------------------------------------------------------------ angelaegbunu's Profile: http://www.excelforum.com/member.php...o&userid=26633 View this thread: http://www.excelforum.com/showthread...hreadid=399069 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Concatenate including a date so that the date appears as a date | Excel Worksheet Functions | |||
date in Cell to change colors if the date is beyond today's date | Excel Discussion (Misc queries) | |||
Making a date go red, if date passes todays date. | Excel Worksheet Functions | |||
Report Date - Date Recv = Days Late, but how to rid completed date | Excel Worksheet Functions | |||
Date updates from worksheet to chart & changes date to a date series! Help!! | Charts and Charting in Excel |