Hi!
on an excel sheet, the first column represents the date of departure on leave, the second term represent and I want the last automatically displays the date of resumption of work.
Thank you for helping me, I am a beginner
Member
Hi!
on an excel sheet, the first column represents the date of departure on leave, the second term represent and I want the last automatically displays the date of resumption of work.
Thank you for helping me, I am a beginner
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little.
-Joe Martin
Member
Format cell for departure and arrival dates = date
Format cell to Number = Number of days
In the arrival date you set your formula
(start date + number of days) And it works, I tested
Keep me informed
If indeed it does not work, look at the DateAdd function in helping, And if you really do not go away come again!
Member
it works, thank you very much, in fact is that I had not changed the format of cells in "date." thank you again
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little.
-Joe Martin
Posting Permissions
Reply With Quote
Bookmarks