Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #20  
Old 05-13-2020, 11:12 AM
jthomas666 jthomas666 is offline Due Date Summary based on multi-sheet spreadsheet Windows 10 Due Date Summary based on multi-sheet spreadsheet Office 2016
Competent Performer
Due Date Summary based on multi-sheet spreadsheet
 
Join Date: Jun 2016
Location: Warner Robins, GA
Posts: 204
jthomas666 will become famous soon enough
Default

sigh. I am missing something very basic on how this spreadsheet calculates dates.

trying to calculate Due Dates for specific project documents:

CDRLs=SRS/STP
DocClass=Projects
Due Types Calendar Day (CD)

Should be very simple--Base Date = 30

not working. I can't figure out if the problem is with the DueType or if it's somewhere in the helper columns.

Suggestions?

As always, thank you so much for your assistance.
Jim
Attached Files
File Type: xlsx DueDate.xlsx (40.6 KB, 9 views)
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Summriez all worksheet in summary work sheet MILADREZAEE Excel 7 05-21-2018 05:01 AM
How to calculate summary progress date time on summary tasks Logotip Project 0 05-16-2017 01:18 AM
Due Date Summary based on multi-sheet spreadsheet Creating a dynamic summary sheet FenelonPaul Excel 5 09-23-2015 07:11 AM
Due Date Summary based on multi-sheet spreadsheet Can a Data Source be one sheet in a multi-sheet Workbook nfotx Mail Merge 1 07-01-2015 12:55 AM
Due Date Summary based on multi-sheet spreadsheet Construct a summary sheet by summing up from one or more than one sheet. PRADEEPB270 Excel 1 11-04-2011 03:46 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:11 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft