Solved how can i track a due date on ms excel 2010 spreadsheet

May 27, 2014 at 11:41:00
Specs: Windows 7
I am trying to keep track of due dates on my spreadsheets. I have some dates that expire annually and the others biennially.

See More: how can i track a due date on ms excel 2010 spreadsheet

Report •


#1
May 27, 2014 at 12:31:11
You'll need to explain what you mean by "keep track of due dates".

For example, are you asking to have them turn a specific color when they get within a month of coming due? Are you asking for pop up messages when a due date is imminent?

We need details, my friend, details.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
May 28, 2014 at 10:29:34
✔ Best Answer
is there a way to have an ms spreadsheet calculate due dates for me instead of me inputting them manually.

The simple answer is yes.

On way, is if you have a date in cell A1
and you wish to add 60 days then a simple:

=A1+60

will return a date, 60 days from now.

There are approximately 20 different commands in Excel that deal with Dates & Time so, if you need help, you will have to be a bit more specific in your explanation.

An example of your worksheet, with Column Letters and Row Numbers would be helpful.
See this How-To, which explains the use of the PRE tags in posting your data.

http://www.computing.net/howtos/sho...

MIKE

http://www.skeptic.com/


Report •

#3
May 28, 2014 at 16:31:28
Thank you.

message edited by gvillafanesr


Report •

Related Solutions

#4
May 28, 2014 at 16:37:01
Yes, how Can I have it turn a different color 5 days before its due date??

message edited by gvillafanesr


Report •

#5
May 28, 2014 at 18:05:18

Report •

#6
May 29, 2014 at 06:23:39
Thanks again. I appreciate your assistance mike.

Report •


Ask Question