Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have created a calendar in excel.
Row 1 shows the days of the week in text format with this formula: =TEXT(WEEKDAY(B2),"dddd" Row 2 shows a future date April 4, 2005 (I created running dates across the row by clicking and dragging) Each month is on a separate worksheet (whcih can be changed if needed). Question: What formula can I use to create running dates (right now they are future dates) for each month that will allow me to skip Saturday and Sunday? I need to display weekdays only, but would like to have everything automated so that I don't have to go in and delete the weekends for each month. Thanks for the help!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Date formula | Excel Worksheet Functions | |||
Need help troubleshooting an array formula XLXP on Win2K | Excel Worksheet Functions | |||
In Excel, I need a date math formula... | Excel Discussion (Misc queries) | |||
Creating a Date Selector in Excel VBA? | Excel Discussion (Misc queries) | |||
How to change (delivery) days and automatically the receive date in an other cell? | Excel Worksheet Functions |