Counting # of days between 2 dates excluding Fri & Sat)
Sorry, I missed you subject part (Fri & Sat)
If this post helps click Yes
--------------
Jacob Skaria
"Jacob Skaria" wrote:
ColumnA - Start Date
ColumnB - End Date
Column C Formula '=B1-A1'
Select the date columns. format cells to Date (Format|Number Tab)
Select the number of days column. format cells to Number (Decimal places 0)
If this post helps click Yes
--------------
Jacob Skaria
"Khaledity" wrote:
Hi,
I am doing a vacation tracking sheet for my subordinates, and I want
to count the number of days they have consumed by entering start date
and end date.
Any advice?
Thanks.
Khaledity
|