How to calculate dates

P

Pat

How would I calculate a project date 60 days from any given date that
includes weekends and holidays. The function will only calcuate weekdays.
 
N

Niek Otten

<includes weekends and holidays>

I assume you mean exclude?

<The function will only calcuate weekdays>

Which function?

Look in HELP for the WORKDAY() function
 
P

Pat

No it has to include weekends and holidays. I'm using the workday function,
which excludes weekends and holidays, and I need to figure out dates that are
60 calendar days from the date of initiaton.

A1 B1
C1

today's date 60 (calendar days) = date project to be
completed
 
D

David Biddulph

If you want only weekdays, use the WORKDAY function.
If you want 60 days on, regardless of weekends and holidays, use =A1+60.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculate End Date (excluding weekends and holidays) 6
Calculating Calendar Dates 4
Calculate days help 2
Calculate 60 days from Start Date - including weekends 5
Calculate Project dates 2
determine workdays 1
Date Calculation Formula- Calendar days minus Holidays 1
if formula returns a weekend - move it forward to next weekday 2

Top