Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Date calculations Date calculations
Register FAQ Mark Forums Read

Reply
 
Thread Tools Display Modes
  #1  
Old 03-03-2022, 01:36 PM
oscarlimerick oscarlimerick is offline Date calculations Windows 8 Date calculations Office 2013
Advanced Beginner
Date calculations 		 
Join Date: Jul 2020
Posts: 57
oscarlimerick is on a distinguished road
Default Date calculations

Good day Excel subject matter experts. I need a formula that will calculate the number of calendar days from the previous row to the row above that and display it as the number of calendar days. See attached spreadsheet for more detail. Many thanks
Attached Files
File Type: xlsx For excel forum.xlsx (11.7 KB, 6 views)
Reply With Quote
  #2  
Old 03-03-2022, 03:41 PM
p45cal's Avatar
p45cal p45cal is offline Date calculations Windows 10 Date calculations Office 2019
Expert
  
Join Date: Apr 2014
Posts: 866
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default
=A5-A4
Format the cell as General.
Reply With Quote
  #3  
Old 03-03-2022, 03:47 PM
oscarlimerick oscarlimerick is offline Date calculations Windows 8 Date calculations Office 2013
Advanced Beginner
Date calculations 		 
Join Date: Jul 2020
Posts: 57
oscarlimerick is on a distinguished road
Default
Yes, that works! That was almost too easy lol, guess I shiould have tried that before posting, thanks for your help
Reply With Quote
Reply

« Previous Thread | Next Thread »
Thread Tools
Display Modes
Linear Mode Linear Mode


Similar Threads
Thread Thread Starter Forum Replies Last Post
Date calculations Incorrect Date Calculations > 12/31/29 Oldfart1944 Excel 4 07-01-2018 11:08 PM
Date calculations Form Driven Date/Time Calculations dnunnally Word VBA 3 08-27-2015 09:56 AM
Date calculations Restrict Date Range Calculations akatz85 Excel 4 03-27-2014 08:46 PM
Date calculations Date fields calculations in Word Template. kckay Word 1 10-22-2012 11:34 PM
30+ days Variable Day Date Calculations via Fields ztag Word 2 01-06-2012 11:12 AM

Other Forums: Access Forums

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

Contact Us - Privacy Statement - Top

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