Hi I have a spreadsheet that has a date of notification in one cell, a date It is required in the next cell and in the next cell I want a countdown days to the due date, I want it so that I can drag don the cell for the next orders can anyone help. Much appreciated
Welcome to the forums
I have done up your requirement in Sheet1, and a modified version of it in Sheet2.
Please refer to the attached and see if that is what you wanted.
SC
Do give a * (bottom left) if the post helped!
A1: Date of Notification
B1: Date Due
C1: =B1-C1 (format this cell as General)
_________________
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!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks