Date Formula

Karen615 · #6 11-22-2024, 06:42 AM

Quote:

Originally Posted by ArviLaanemets

Or in A3 use (assumed the worksheet is never used at weekends, and you have to cope with state holidays otherwise)

Code:

=TODAY() - IIF(WEEKDAY(TODAY(),2)=1,3,1)

In case you need to take holidays also into account, you need a hidden calendar table with state holidays marked, and with a calculated column which returns the number of days to previous workday in case of holiday or weekend (p.e. for my country, this may be up to 5 days if I remember correctly), and 0 in case of workday. The formula in A3 will calculate the previous workday based on this hidden table.

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

Also, I do need to deal with holidays. I'm not sure how to set up that hidden calendar.

Your help is greatly appreciated.
Thank you,
Karen

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