ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   CREATING A CUSTOM FILL WITH WORKDAYS (https://www.excelbanter.com/excel-discussion-misc-queries/86596-creating-custom-fill-workdays.html)

Teeder

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

Peo Sjoblom

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




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