LinkBack URL
About LinkBacks
Hello everyone
If I input a date and want another cell to automatically input a date 5 business days after the one I type in, what is the forumala for that?
Thanks for your help
Hello everyone
If I input a date and want another cell to automatically input a date 5 business days after the one I type in, what is the forumala for that?
Thanks for your help
Supposibg the input date is in cell A1 and the date five days later in cell B1.
Then the formula in cell B1 has to be =A1+5.
The dates in Excel are represented by numbers. Todays date is the number 39831. 23 of January is 39836.
great thank you this helped
To get 5 business days use he Workday function. If the date is in A1
=WORKDAY(A1,5)
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks