Thread: [Solved] Date Formula
View Single Post
 
Old 11-21-2024, 07:53 PM
macropod's Avatar
macropod macropod is online now Windows 10 Office 2016
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,382
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
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
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote