ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   In MS Excel 03, how do I determine an end date (with weekends)? (https://www.excelbanter.com/excel-worksheet-functions/91617-ms-excel-03-how-do-i-determine-end-date-weekends.html)

Jen

In MS Excel 03, how do I determine an end date (with weekends)?
 
What function is used in MS Excel 2003 to find an end date to a project based
on the start date and number of days lapsed? The WORKDAY function only uses
workdays, but I need 7 days in a week people!!! -Thanks

Ardus Petus

In MS Excel 03, how do I determine an end date (with weekends)?
 
Say your start date is in A1, nb. of days in B1
=A1+B1
Format as date

HTH
--
AP

"Jen" a écrit dans le message de news:
...
What function is used in MS Excel 2003 to find an end date to a project
based
on the start date and number of days lapsed? The WORKDAY function only
uses
workdays, but I need 7 days in a week people!!! -Thanks





All times are GMT +1. The time now is 02:28 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com