![]() |
CREATING A CUSTOM FILL WITH WORKDAYS
Is there any way that you can enter a date, display it in days and have Excel
fill in the workdays (not weekends or holidays) from that point on? Thank you in advance for any help you can provide. Teeder |
CREATING A CUSTOM FILL WITH WORKDAYS
Don't know what version of Excel you are using but if you copy drag using
the right mouse button you'll have that option with dates in at least from Excel 2002 onwards (fill weekdays) -- Regards, Peo Sjoblom http://nwexcelsolutions.com "Teeder" wrote in message ... Is there any way that you can enter a date, display it in days and have Excel fill in the workdays (not weekends or holidays) from that point on? Thank you in advance for any help you can provide. Teeder |
CREATING A CUSTOM FILL WITH WORKDAYS
YOU ROCK!!!
Thanks!! Teeder "Peo Sjoblom" wrote: Don't know what version of Excel you are using but if you copy drag using the right mouse button you'll have that option with dates in at least from Excel 2002 onwards (fill weekdays) -- Regards, Peo Sjoblom http://nwexcelsolutions.com "Teeder" wrote in message ... Is there any way that you can enter a date, display it in days and have Excel fill in the workdays (not weekends or holidays) from that point on? Thank you in advance for any help you can provide. Teeder |
All times are GMT +1. The time now is 07:10 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com