The UK Home Automation Archive

Archive Home
Group Home
Search Archive


Advanced Search

The UKHA-ARCHIVE IS CEASING OPERATIONS 31 DEC 2024


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[OT] Any Excel whizzes out there??



Sorry, I know there's lots of OT posts at the mo, but I've got a bit of an
Excel prob...

I've got a cell working out the number of days between the current date,
and
an entered date (i.e. a date when an action will become due).  This is
"=DAYS360($D$1,D13)", where D1 is todays date and D13 is the
typed due date.
Is there an easy way to have it calculate working days (or even week days)
rather that straight calendar days?

Thx, Pete



[Non-text portions of this message have been removed]



Home | Main Index | Thread Index

Comments to the Webmaster are always welcomed, please use this contact form . Note that as this site is a mailing list archive, the Webmaster has no control over the contents of the messages. Comments about message content should be directed to the relevant mailing list.