I need to dates in two columns - one for record date and the other for ex date. The record date is one day before the ex date. Rather than go manually and minus one day away from the record date for the ex date can i do a formula for this?
Hopefully i havent confused everyone and you know what i need.
Thanks again - newbie excel user
A1 - Record Date
B1: =IF(A1>0, A1-1, "")
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
Thanks for that.
But just say I want to use only business days i.e monday to friday?
Try:
=IF(A1<=0,"",WORKDAY( A1,-1))
Click the star icon in left-corner of my post if you find my post userful!
Quang PT
quangphanidico@yahoo.com
PM me: Y!M: quangphanidico
=if(and(A1>0,Weekday(A1,1)<>2),A1-1,A1-3). This formula assumes that the record date would always be a Monday through Friday.
Alan
Click the * below to say thanks.
Database Principles
Pivot Table Tips
Good Excel Video Tutorials
Sumifs or SumProduct
DataPig Access Tutorials
MS Query Tutorial
Worst Pie Chart Ever?
i think we can even do this with the simpler formula like =A1-1 and foramat the cell into date format that's it
Shridhar
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks