Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 102
  • Last Modified:

Workweek - add 6 months and 60 days

Experts, I have fiddled around with this workweek function and I cant get it to work.  

How can I modify the below for Workweek?  I am adding 6 months and 60 days.  I have 180 for 6 months but I dont believe that is totally accurate.  If know how to add 6 months then that is what I am after.  I am adding only calendar and not days counted M-F.  

=H114+180+60

thank you
0
pdvsa
Asked:
pdvsa
  • 3
  • 2
2 Solutions
 
als315Commented:
With EDATE you can add monthes to your date:
=EDATE(H114,6)
0
 
pdvsaProject financeAuthor Commented:
I am doing something wrong.  It is returning Weekend dates.  I am adding 6 months then adding additoinal 60 days and this is what the "8" is.  (6 +2)

you see something?
=WORKDAY(EDATE(H114,8),-1,1)
0
 
Katie PierceCommented:
Try this:

=IF(WEEKDAY(EDATE(H114,6),2)=7,EDATE(H114,6)+1,IF(WEEKDAY(EDATE(H114,6),2)=6,EDATE(H114,6)+2,EDATE(H114,6)))

This will determine if your end date falls on a Saturday or a Sunday, it will push it to the next Monday.
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
pdvsaProject financeAuthor Commented:
Katie:  I am getting something not expected and wondering if your formula adds 6 months or is it 8?  I am thinking it is 6 but my original question was to add 8 total (6 months + 60 days which is about 8 months)

let me know..
0
 
Katie PierceCommented:
Oh, sorry, I read 6 months.  Yes, replace the 6 with an 8 in each instance to make it +8 months:

=IF(WEEKDAY(EDATE(H114,8),2)=7,EDATE(H114,8)+1,IF(WEEKDAY(EDATE(H114,8),2)=6,EDATE(H114,8)+2,EDATE(H114,8)))
0
 
pdvsaProject financeAuthor Commented:
thank you...it works!
0

Featured Post

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now