Date Formula

		Microsoft Office Forums > Microsoft Excel > Excel
Date Formula

FAQ

Thread Tools

Display Modes

11-21-2024, 06:20 PM

Karen615

Windows 11 Date Formula

Office 2021

Competent Performer

Join Date: Jun 2011

Location: Chicago

Posts: 145

Date Formula

Hello,

In my spreadsheet (in cell A4), I have the formula =TODAY(). In cell A3, the formula is: =A4-1. The formula in cell A3 works well Tue-Fri, but when I come into work on Monday, I need cell A3 to display a Friday date and not a Sunday date. Is there any way to modify this formula so it skips over weekends?

Your help is greatly appreciated,
Karen

« 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
Formula to return a date	caz46	Excel	3	04-15-2015 08:59 AM
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 06:51 AM.