June 6th, 2010, 04:58 AM
posted to microsoft.public.excel.worksheet.functions
|
|
Calculating pay dates
Ashish Mathur,
your suggestion was helpful, but I found that adding
=text(your_formula,"mm/dd/yyyy") got me to where I needed to be.
Thank you much!
BW
"Ashish Mathur" wrote:
Hi,
You can try this
=C23+CHOOSE(WEEKDAY(C23,2),3,2,1,0,-1,5,4)
--
Regards,
Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
"BW" wrote in message
...
If a date is a friday, I want to display the previous Thursday
(MM/DD/YYYY).
If a date is a Saturday - Thursday, I want to display the Thursday as a
date
(MM/DD/YYYY).
To illustrate, if the date is 05/28/2010, I want to display 05/27/2010.
If
the date is 05/29/2010 - 06/03/2010, I want to display 06/03/2010.
I hope this is clear.
Thank you,
BW
|