Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Date Formula Date Formula
Register FAQ

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 11-22-2024, 06:35 AM
Karen615 Karen615 is offline Date Formula Windows 11 Date Formula Office 2021
Competent Performer
Date Formula 		 
Join Date: Jun 2011
Location: Chicago
Posts: 145
Karen615 is on a distinguished road
Default
Quote:
Originally Posted by macropod View Post
You could use:
For a dynamic formula that updates daily, you could use:
Quote:
=TODAY()-1-(MOD(TODAY(),7)=2)*2
For a formula that references the date in another cell, you could use:
Quote:
=A4-1-(MOD(A4,7)=2)*2
=TODAY()-1-(MOD(TODAY(),7)=2)*2

Thank you so much for your help. If you have a chance, would you please explain this formula in layman's terms?

Your help is greatly appreciated.
Thank you,
Karen
Reply With Quote
 

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
Date Formula Issue matteu1 Mail Merge 1 07-23-2018 04:53 AM
Formula for looking at 1 cell with a date and then comparing it to four date ranges LearningMom Excel 3 10-27-2017 12:44 PM
Date Formula Formula to return a date caz46 Excel 3 04-15-2015 08:59 AM
Date Formula Need a date formula MPAVLAS Excel 3 08-12-2010 10:04 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:49 PM.

Contact Us - Privacy Statement - Top

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